| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display leading zeros in numeric value without converting to text
I'm trying to use a numeric value with a leading zero, but the format keeps
dropping the leading zero. I've tried custom formatting, but it also drops the lead zero. The only way to display the leading zero is to format the value to text, but then it places the text tag in the cell, which I don't want. Is there a way to format a cell to allow leading zeros without converting or formatting the value as text? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to copy a number into a text cell, keeping leading zeros? | Charts and Charting in Excel | |||
| Turning off auto formatting | Excel Discussion (Misc queries) | |||
| removing leading zeros in numeric fields | Excel Discussion (Misc queries) | |||
| Spliting a number with leading zeros | Excel Discussion (Misc queries) | |||
| Adding Leading Zeros to Text | Excel Discussion (Misc queries) | |||
Threaded Mode
