auto edit problem

  • Thread starter Thread starter Julie
  • Start date Start date
J

Julie

Excel keeps automatically removing "0" from the front of a #, but I want to
keep them there
 
When you enter a "number" string with leading zeros in a cell that's
formatted for a number, or general, Excel just deletes the leading zeros and
converts the remaining digits to a number. If you want to retain the
leading zeros in a string, either pre-format the cell for TEXT, or type an
apostrophe before entering the string.

Vaya con Dios,
Chuck, CABGx3
 
Back
Top