Excell deletes 0 when its the first number in a string
 

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.

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


"dustin1138" wrote in message
...
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.

Dustin

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

or

pre-fix the data with ' (single apostrophe)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"dustin1138" wrote in message
...
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.