If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Applying percentage calculator to table
Hi ............ Grateful of any help to change a table of figures in one currency to another by applying a percentage calculator, eg Pounds sterling to US Dollars by mutiplying all figures in all cells by 1.73. I can create the formula to make the change, but can't seem to apply it to the figures in the individual cells. Thanks for any help. Joe -- Manicjoe ------------------------------------------------------------------------ Manicjoe's Profile: http://www.excelforum.com/member.php...o&userid=29325 View this thread: http://www.excelforum.com/showthread...hreadid=490422 |
#2
|
|||
|
|||
Applying percentage calculator to table
In an empty cell, enter the number 1.73.
EditCopy Select your table of figures. EditPaste special, check Multiply -- Kind regards, Niek Otten "Manicjoe" wrote in message ... Hi ............ Grateful of any help to change a table of figures in one currency to another by applying a percentage calculator, eg Pounds sterling to US Dollars by mutiplying all figures in all cells by 1.73. I can create the formula to make the change, but can't seem to apply it to the figures in the individual cells. Thanks for any help. Joe -- Manicjoe ------------------------------------------------------------------------ Manicjoe's Profile: http://www.excelforum.com/member.php...o&userid=29325 View this thread: http://www.excelforum.com/showthread...hreadid=490422 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help again from Ken Snell (Query) | Randy | Running & Setting Up Queries | 22 | August 29th, 2005 08:15 PM |
Help with relationship plase | Rock | Database Design | 5 | July 4th, 2005 03:54 AM |
Access combo box-show name, not ID, in table? | write on | New Users | 30 | April 30th, 2005 09:11 PM |
Manual line break spaces on TOC or Table of tables | Eric | Page Layout | 9 | October 29th, 2004 04:42 PM |
COMPARE THE TWO TABLES | Stefanie | General Discussion | 0 | June 4th, 2004 04:36 PM |