| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display leading zeros in numeric value without converting to text
Hi,
custom format as "0"0.00 note, the figures will appear as 01234 but on the formula bar you will see 1234. hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Gmonny" escreveu: 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? |
| Reply |
| 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) | |||
Hybrid Mode
