Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Number Format
I have a column with numbers like: 33.35 21.01 42.7 12.01 21 I need to convert them all to: 3335 2101 4270 1201 2100 What would be the easiest way to accomplish this? Can it be done with a custom number format? Thanks! -- TimmerSuds ------------------------------------------------------------------------ TimmerSuds's Profile: http://www.excelforum.com/member.php...o&userid=35596 View this thread: http://www.excelforum.com/showthread...hreadid=553615 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Number Format
"TimmerSuds" wrote
in message ... I have a column with numbers like: 33.35 21.01 42.7 12.01 21 I need to convert them all to: 3335 2101 4270 1201 2100 What would be the easiest way to accomplish this? Can it be done with a custom number format? If you want to change the number, rather than merely display in a different format, the easiest way is to type 100 into a spare cell, copy that, select the cells you want to change, then Edit/ Paste Special/ Multiply. -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Number Format | Excel Discussion (Misc queries) | |||
Custom Number format question | Excel Discussion (Misc queries) | |||
Custom number format - Accounting | Excel Worksheet Functions | |||
Custom number format always defaults last number to 0. | Excel Discussion (Misc queries) | |||
How do I format a cell for a custom part number? | Excel Discussion (Misc queries) |