Re: Inserting "/G50" into hardcoded numbers

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

Make a copy of your workbook first!

--
Kind regards,

Niek Otten

"marksuza" <marksuza.243jxz_1141394401.525@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:marksuza.243jxz_1141394401.525@xxxxxxxxxxxxxxxxxxxxxxxx

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?action=getinfo&userid=2659
View this thread: http://www.excelforum.com/showthread.php?threadid=518699



.

Relevant Pages

  • Re: How do I calculate amortization to show months?
    ... Look in HELP for the NPER function. ... Don't forget to divide your % by 12 if ... Kind Regards, ... Prev by Date: ...
    (microsoft.public.excel.newusers)
  • Re: IRR showed #NUM!
    ... I followed your step but divide by 1000...yup, ... Kind regards, ... Microsoft MVP - Excel ... excel file but contain the same value, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: how do i convert a column of minutes into hours
    ... In an empty cell, enter the number 60. ... Edit>Paste special>check Divide ... Kind regards, ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Copy & divide by
    ... Edit>Paste Special, check Divide ... Kind regards, ... Microsoft MVP - Excel ...
    (microsoft.public.excel.misc)