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

Select G5. EditCopy. Select your numbers. EditPaste Special, check Divide

Make a copy of your workbook first!

--
Kind regards,

Niek Otten

"marksuza" wrote in
message ...

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

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...


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=518699

Thanks for the help.

Regards,

Marcos


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

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

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

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

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

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