| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Too many different cell format | Excel Discussion (Misc queries) | |||
| format column for unique values only | Excel Worksheet Functions | |||
| Format of cells problem... | Excel Discussion (Misc queries) | |||
| protecting format | Excel Discussion (Misc queries) | |||
| Format cells to display truncated values? | Excel Discussion (Misc queries) | |||
Linear Mode
