Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel spreadsheet
But what I was really looking for was a way to keep the leading zero(s) for
any length (4, 6, 3, 9, etc). Using this method, I would have to be careful to reformat cells with numbers less than 5 digits (to avoid having extra leading zeros at the front). Also the same for numbers of more than 5 digits, as they would still drop leading zeros. -- Mike D. |
#3
|
|||
|
|||
You could use separate formats for each cell (lots of work).
Or you could format the cells as Text and just type in your values. Or you could start each entry with an apostrophe: '001234 Both those last two options will treat your numbers as text, though. Michael wrote: But what I was really looking for was a way to keep the leading zero(s) for any length (4, 6, 3, 9, etc). Using this method, I would have to be careful to reformat cells with numbers less than 5 digits (to avoid having extra leading zeros at the front). Also the same for numbers of more than 5 digits, as they would still drop leading zeros. -- Mike D. -- 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) | |||
identify duplicate data in excel spreadsheet | Excel Discussion (Misc queries) | |||
copy and paste excel spreadsheet into autocad | Excel Discussion (Misc queries) | |||
Excel should let me circle a cell or number in the spreadsheet fo. | Excel Discussion (Misc queries) | |||
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) |