| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
A zero as a first digit
How can I get in a cell a zero as a first digit, for instance 01102008?
I'm using Excel 97. Thanks in advance! QV |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
A zero as a first digit
I cannot test it in Excel 97 but maybe some of the methods available in Excel
2003 work also in 97. 1. Format cell like text. 2. Put an apostrophe (') before digits: '01102008 3. If all cells are of the same length (say 8 digits) then custom format cells with format code "00000000" (8 zero digits) Regards, Stefi €˛QV€¯ ezt Ć*rta: How can I get in a cell a zero as a first digit, for instance 01102008? I'm using Excel 97. Thanks in advance! QV |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
A zero as a first digit
To add to Stefi's reply number 1, the cell needs to be formatted as text
*before* you enter the number. Once Excel has stored the data as a number, rather than text, then reformatting the cell subsequently as text won't retrieve the leading zeroes which have already been lost. -- David Biddulph "Stefi" wrote in message ... I cannot test it in Excel 97 but maybe some of the methods available in Excel 2003 work also in 97. 1. Format cell like text. 2. Put an apostrophe (') before digits: '01102008 3. If all cells are of the same length (say 8 digits) then custom format cells with format code "00000000" (8 zero digits) Regards, Stefi "QV" ezt ķrta: How can I get in a cell a zero as a first digit, for instance 01102008? I'm using Excel 97. Thanks in advance! QV |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
A zero as a first digit
Thanks David for your correcting!
Stefi €˛David Biddulph€¯ ezt Ć*rta: To add to Stefi's reply number 1, the cell needs to be formatted as text *before* you enter the number. Once Excel has stored the data as a number, rather than text, then reformatting the cell subsequently as text won't retrieve the leading zeroes which have already been lost. -- David Biddulph "Stefi" wrote in message ... I cannot test it in Excel 97 but maybe some of the methods available in Excel 2003 work also in 97. 1. Format cell like text. 2. Put an apostrophe (') before digits: '01102008 3. If all cells are of the same length (say 8 digits) then custom format cells with format code "00000000" (8 zero digits) Regards, Stefi "QV" ezt Ć*rta: How can I get in a cell a zero as a first digit, for instance 01102008? I'm using Excel 97. Thanks in advance! QV |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert 2 digit month to 4 digit years and months | Excel Worksheet Functions | |||
| Color a single digit in a mult-digit number cell | Excel Discussion (Misc queries) | |||
| How do I identify the 7th digit in a 13 digit number, then establi | Excel Worksheet Functions | |||
| Tell users how to sort 5 digit and 9 digit zipcodes correctly aft. | New Users to Excel | |||
| When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) | |||
Linear Mode
