J
Jon Gaster
I have a complex spreadsheet, about four linked worksheets all in US
dollars. I have been asked to produce the same thing in pounds
sterling. Is there any way that I can divide the value of all cells by
say 1.9 to give me the sterling value - I have created a new cell with
the correct exchange rate so I can change that at any time but I am not
sure how I can apply it to all cells.
Many thanks for any assistance
dollars. I have been asked to produce the same thing in pounds
sterling. Is there any way that I can divide the value of all cells by
say 1.9 to give me the sterling value - I have created a new cell with
the correct exchange rate so I can change that at any time but I am not
sure how I can apply it to all cells.
Many thanks for any assistance