software

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: www.excelforum.com/member.php...foamp;userid=2659
View this thread: www.excelforum.com/showthread...hreadid=518699Select G5. Editgt;Copy. Select your numbers. Editgt;Paste Special, check Divide

Make a copy of your workbook first!

--
Kind regards,

Niek Otten

quot;marksuzaquot; gt; wrote in
message ...
gt;
gt; Hi,
gt;
gt; I was wondering if anybody could help me with a problem I am having. I
gt; have a table with several row and columns with hardcoded number (which
gt; are fed to another table). I was asked to translate them into a
gt; different currency, is there an easy way I can insert '/G5' (exchange
gt; rate) into each of the cells to make it a formula. Too many numbers to
gt; do it manually. I appreciate the help
gt;
gt; Thanks.
gt;
gt;
gt; --
gt; marksuza
gt; ------------------------------------------------------------------------
gt; marksuza's Profile:
gt; www.excelforum.com/member.php...foamp;userid=2659
gt; View this thread: www.excelforum.com/showthread...hreadid=518699
gt;

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

0,00quot;put your text here between quotesquot;

should work...--
robert111
------------------------------------------------------------------------
robert111's Profile: www.excelforum.com/member.php...oamp;userid=31996
View this thread: www.excelforum.com/showthread...hreadid=518699
Thanks for the help.

Regards,

Marcos--
marksuza
------------------------------------------------------------------------
marksuza's Profile: www.excelforum.com/member.php...foamp;userid=2659
View this thread: www.excelforum.com/showthread...hreadid=518699One 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:
gt;
gt; Hi,
gt;
gt; I was wondering if anybody could help me with a problem I am having. I
gt; have a table with several row and columns with hardcoded number (which
gt; are fed to another table). I was asked to translate them into a
gt; different currency, is there an easy way I can insert '/G5' (exchange
gt; rate) into each of the cells to make it a formula. Too many numbers to
gt; do it manually. I appreciate the help
gt;
gt; Thanks.
gt;
gt; --
gt; marksuza
gt; ------------------------------------------------------------------------
gt; marksuza's Profile: www.excelforum.com/member.php...foamp;userid=2659
gt; View this thread: 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:
gt;
gt; Hi,
gt;
gt; I was wondering if anybody could help me with a problem I am having. I
gt; have a table with several row and columns with hardcoded number (which
gt; are fed to another table). I was asked to translate them into a
gt; different currency, is there an easy way I can insert '/G5' (exchange
gt; rate) into each of the cells to make it a formula. Too many numbers to
gt; do it manually. I appreciate the help
gt;
gt; Thanks.
gt;
gt; --
gt; marksuza
gt; ------------------------------------------------------------------------
gt; marksuza's Profile: www.excelforum.com/member.php...foamp;userid=2659
gt; View this thread: www.excelforum.com/showthread...hreadid=518699

--

Dave Peterson

Nice, Dave! Didn't know that one.

--
Kind regards,

Niek Otten

quot;Dave Petersonquot; gt; wrote in message
...
gt; One more...
gt;
gt; Find an empty cell.
gt; Put =$g$50 in it.
gt; edit|copy that cell
gt; select the range to adjust
gt; edit|paste special|divide
gt; Clean up that cell with =$g$50 in it.
gt;
gt; Now you have formulas that look like:
gt;
gt; =(1234.32)/$g$50
gt;
gt; So you can change G50 and all of that range will adjust.
gt;
gt; marksuza wrote:
gt;gt;
gt;gt; Hi,
gt;gt;
gt;gt; I was wondering if anybody could help me with a problem I am having. I
gt;gt; have a table with several row and columns with hardcoded number (which
gt;gt; are fed to another table). I was asked to translate them into a
gt;gt; different currency, is there an easy way I can insert '/G5' (exchange
gt;gt; rate) into each of the cells to make it a formula. Too many numbers to
gt;gt; do it manually. I appreciate the help
gt;gt;
gt;gt; Thanks.
gt;gt;
gt;gt; --
gt;gt; marksuza
gt;gt; ------------------------------------------------------------------------
gt;gt; marksuza's Profile:
gt;gt; www.excelforum.com/member.php...foamp;userid=2659
gt;gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=518699
gt;
gt; --
gt;
gt; 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:
gt;
gt; Nice, Dave! Didn't know that one.
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;Dave Petersonquot; gt; wrote in message
gt; ...
gt; gt; One more...
gt; gt;
gt; gt; Find an empty cell.
gt; gt; Put =$g$50 in it.
gt; gt; edit|copy that cell
gt; gt; select the range to adjust
gt; gt; edit|paste special|divide
gt; gt; Clean up that cell with =$g$50 in it.
gt; gt;
gt; gt; Now you have formulas that look like:
gt; gt;
gt; gt; =(1234.32)/$g$50
gt; gt;
gt; gt; So you can change G50 and all of that range will adjust.
gt; gt;
gt; gt; marksuza wrote:
gt; gt;gt;
gt; gt;gt; Hi,
gt; gt;gt;
gt; gt;gt; I was wondering if anybody could help me with a problem I am having. I
gt; gt;gt; have a table with several row and columns with hardcoded number (which
gt; gt;gt; are fed to another table). I was asked to translate them into a
gt; gt;gt; different currency, is there an easy way I can insert '/G5' (exchange
gt; gt;gt; rate) into each of the cells to make it a formula. Too many numbers to
gt; gt;gt; do it manually. I appreciate the help
gt; gt;gt;
gt; gt;gt; Thanks.
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; marksuza
gt; gt;gt; ------------------------------------------------------------------------
gt; gt;gt; marksuza's Profile:
gt; gt;gt; www.excelforum.com/member.php...foamp;userid=2659
gt; gt;gt; View this thread:
gt; gt;gt; www.excelforum.com/showthread...hreadid=518699
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson

--

Dave Peterson