| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep Leading Zero
You can also enter the 'number' as 'o123 (leading quote, and then right
justify it This will still 'function' as a numeric value -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Sean Timmons" wrote in message ... This has to be an easy one, but I can't find it. How do I retain the leading zero in a number and retain number formatting? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display leading zeros in numeric value without converting to text | Excel Discussion (Misc queries) | |||
| Leading zeroes get dropped when converted to text | Excel Discussion (Misc queries) | |||
| Keeping leading 0's | Excel Discussion (Misc queries) | |||
| Leading Zeros | Excel Discussion (Misc queries) | |||
| Remove leading space | Excel Worksheet Functions | |||
Threaded Mode
