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!

Niek Otten wrote:

Nice, Dave! Didn't know that one.

--
Kind regards,

Niek Otten

"Dave Peterson" wrote in message
...
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.

marksuza wrote:

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.

--
marksuza
------------------------------------------------------------------------
marksuza's Profile:
http://www.excelforum.com/member.php...fo&userid=2659
View this thread:
http://www.excelforum.com/showthread...hreadid=518699

--

Dave Peterson

--

Dave Peterson