by James Sigona <jsigona@[EMAIL PROTECTED]
>
Nov 26, 2006 at 08:38 PM
I don't know if this is the most efficient way, but you could insert a new
worksheet into the file and start in cell A1 and link it to one of your
master worksheets by entering the formula to divide the master number by
1.9... Then you can just drag the autofill to spread the similar formula
through the whole worksheet.
Hope that helps.
JS
On 11/2/06 11:02 AM, in article
1162494169.433584.11520@[EMAIL PROTECTED]
"jonsreceipts@[EMAIL PROTECTED]
" <jonsreceipts@[EMAIL PROTECTED]
> wrote:
> 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 exhange 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
>
