| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I format fields to show preceding zeros?
I am having a difficult time to format a field that shows the preceding
zeros, for example, 000210 shows as 210. When I look at the number is shows 000210, but when I put my mouse on the field it only shows 210. I'm trying to run a VLOOKUP and the table I imported has the preceeding zeros and I can not change the formatting... So I'm trying to match. Anyone have any suggestions? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| leading zeros in text format | Excel Discussion (Misc queries) | |||
| Format a cell to keep leading zeros. | New Users to Excel | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Discussion (Misc queries) | |||
| How to show zeros (0) as "slashed" to eliminate confusion with "O. | Excel Discussion (Misc queries) | |||
| Preceding Zeros... | Excel Worksheet Functions | |||
Threaded Mode
