View Single Post
  #2   Report Post  
CLR
 
Posts: n/a
Default

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.