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
|