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 |
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 |
All times are GMT +1. The time now is 12:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com