| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Excel cell format
how can i display preceding zeros in excel without formatting as text?
|
|
#2
|
|||
|
|||
|
In article ,
"rockfam8" wrote: how can i display preceding zeros in excel without formatting as text? Precede your entry with an apostrophe. For example... '012345 Hope this helps! |
|
#3
|
|||
|
|||
|
Or give it a custom format like
00000 (as many 0's as you need) rockfam8 wrote: how can i display preceding zeros in excel without formatting as text? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Can't format cell color/text color in Office Excel 2003 in fil | Excel Discussion (Misc queries) | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Discussion (Misc queries) | |||
| Using Jet to read excel file returns blank for last cell - sometim | Excel Discussion (Misc queries) | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
