Inserting "/G50" into hardcoded numbers

[marksuza]

Hi,

I was wondering if anybody could help me with a problem I am having. I
have a table with several row and columns with hardcoded number (which
are fed to another table). I was asked to translate them into a
different currency, is there an easy way I can insert '/G5' (exchange
rate) into each of the cells to make it a formula. Too many numbers to
do it manually. I appreciate the help

Thanks.

 

[Niek Otten]

Select G5. Edit>Copy. Select your numbers. Edit>Paste Special, check Divide

Make a copy of your workbook first!

 

[robert111]

try format cell, custom, select the 0.00 option, or any other you
prefer, and alter it to

0,00"put your text here between quotes"

should work...

 

[marksuza]

Thanks for the help.

Regards,

Marcos

 

[Dave Peterson]

One more...

Find an empty cell.
Put =$g$50 in it.
edit|copy that cell
select the range to adjust
edit|paste special|divide
Clean up that cell with =$g$50 in it.

Now you have formulas that look like:

=(1234.32)/$g$50

So you can change G50 and all of that range will adjust.

 

[Dave Peterson]

I used $g$50 (from the subject). Change it to $g$5 if you need to.

 

[Niek Otten]

Nice, Dave! Didn't know that one.

 

[Dave Peterson]

I like that one, too.

I think I noticed it a few years ago (by mistake). And I've gotten to use it in
a reply twice in the last two days!