T
Tami
HELP!! I have a column in a spreadsheet that may have
leading zero's (i.e., 000123 or 0123 or 0ABC). When I
try entering 000123, the zeros are dropped (when entering
0ABC, it is entered correctly). I have tried formatting
the column all kinds of different ways. If I type
in '00123, the leading zeros are kept but I don't want to
have to go through the entire spreadsheet and do that.
Is there a formula I can put in that will keep the
leading zeros for numeric numbers?
Thanks in advance for your help.
Tami
leading zero's (i.e., 000123 or 0123 or 0ABC). When I
try entering 000123, the zeros are dropped (when entering
0ABC, it is entered correctly). I have tried formatting
the column all kinds of different ways. If I type
in '00123, the leading zeros are kept but I don't want to
have to go through the entire spreadsheet and do that.
Is there a formula I can put in that will keep the
leading zeros for numeric numbers?
Thanks in advance for your help.
Tami