Excell deletes 0 when its the first number in a string

D

dustin1138

Anyone know how I can turn off the option that deletes 0 when its the first
number in a string?

everytime I tyoe in a number such as 0987
it deletes the 0 at the begining.
 
C

CLR

Either pre-format the cell as TEXT, or type an apostrophe before the leading
zero...........the apostrophe will not be seen in the cell or printout, but
will format that cell as TEXT..........

Vaya con dios,
Chuck, CABGx3
 
N

Nick Hodge

Dustin

Format the cell as text *before* entering data (Format>Cells...Text)

or

pre-fix the data with ' (single apostrophe)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
Top