| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Displaying leading zeros in an Excel spreadsheet
How can I display leading zeros in an Excel spreadsheet? I am a librarian
trying to type in call #s (for example 001.245) and cannot get zeros to display in front of other numbers. Clicking zero values at the View tab under Tools - Options does not work for leading zeros. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Format a cell to keep leading zeros. | New Users to Excel | |||
| How do I display leading zeros so I can export a fixed in Excel? | Excel Discussion (Misc queries) | |||
| How do I password protect cells in a spreadsheet created in Excel | Excel Worksheet Functions | |||
| How do I password protect cells in a spreadsheet created in Excel | Excel Worksheet Functions | |||
Threaded Mode
