Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Leading zero
How can I reset the default to show a leading zero? At this time I have to
use the apostrophe in order for it to show. |
#2
|
|||
|
|||
Leading zero
one way;
format cells to text HTH "Firefli" wrote: How can I reset the default to show a leading zero? At this time I have to use the apostrophe in order for it to show. |
#3
|
|||
|
|||
Leading zero
Depends on whether the VALUE has to ahve a leading zero, or just the DISPLAY.
If the VALUE must have a leading zero, use Ray's suggestion. If it's just the display, use a custom format (Format-Cells-Number-Custom) like "000000" which will show the value 123 as 000123 and the number 1234567 as 1234567 "Firefli" wrote: How can I reset the default to show a leading zero? At this time I have to use the apostrophe in order for it to show. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove leading space | Excel Worksheet Functions | |||
Spliting a number with leading zeros | Excel Discussion (Misc queries) | |||
Concatenation with leading zeros | Excel Worksheet Functions | |||
Leading zeros | Excel Discussion (Misc queries) | |||
CSV leading zeroes | Excel Discussion (Misc queries) |