auto edit problem
 

Excel keeps automatically removing "0" from the front of a #, but I want to
keep them there

auto edit problem
 

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



"Julie" wrote:

Excel keeps automatically removing "0" from the front of a #, but I want to
keep them there