Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format numbers in multiples of 1000
I have a number of budget pages which have been laid out as 000's. ie. if the
budget displays 100 then the figure should be read as 100,000. If the figure is .5 then it should be read as 500. what I want to do is change this to show the full value. I thought there was an option in paste special to multiply each number being pasted by a given number. However, I can't find this option. Any suggestions would be appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format numbers in multiples of 1000
Yes, there is an option to do that. Put 1000 in an empty cell and copy that cell then select the range of cells you wish to multiply by 1000 and use Edit Paste Special Multiply -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=511568 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format numbers in multiples of 1000
Perfect, that's exactly what I was looking for.
Thanks "daddylonglegs" wrote: Yes, there is an option to do that. Put 1000 in an empty cell and copy that cell then select the range of cells you wish to multiply by 1000 and use Edit Paste Special Multiply -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=511568 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional format numbers | Excel Worksheet Functions | |||
Change CSV-load cell format from GENERAL to TEXT for numbers? | Excel Discussion (Misc queries) | |||
Format numbers in chart datatable | Charts and Charting in Excel | |||
Function Help | Excel Worksheet Functions | |||
Amortization Schedule | Excel Worksheet Functions |