Format Values to specified length
I have a list of values that I need to format to the specific format below: +000000010.12345678 However, the list of values have 10.1, 10.25.... how can I throw in the extra 0 before and after the decimal? -- kwiklearner ------------------------------------------------------------------------ kwiklearner's Profile: http://www.excelforum.com/member.php...o&userid=31909 View this thread: http://www.excelforum.com/showthread...hreadid=520601 |
Format Values to specified length
<Format<Cells
Click on "Number" tab Click on "Custom" Enter this: 000000000.000000000 Add/Take away 0's to fit your needs. -- Regards, Dave "kwiklearner" wrote: I have a list of values that I need to format to the specific format below: +000000010.12345678 However, the list of values have 10.1, 10.25.... how can I throw in the extra 0 before and after the decimal? -- kwiklearner ------------------------------------------------------------------------ kwiklearner's Profile: http://www.excelforum.com/member.php...o&userid=31909 View this thread: http://www.excelforum.com/showthread...hreadid=520601 |
All times are GMT +1. The time now is 05:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com