0 number

[Loi]

Hi,

social security number has 7 numbers. However, when I type
0454636, 0 will be gone.

Ex: Type 0454636. It will become 454636.


I have almost 8 columns stored social security numbers.
Please show me how to fix the problem.

Thank you
Loi

 

[Patti]

Try format cells -- custom and type 0000000 in the box.

 

[icestationzbra]

if you are not using these SSNs for any numerical calculations a
numbers, then you could format the cells as Text, that would hel
retain the leading 0s

 

[Lady Layla]

format cells before putting the numbers in them

Format Cells Number Special SSN





: Hi,
:
: social security number has 7 numbers. However, when I type
: 0454636, 0 will be gone.
:
: Ex: Type 0454636. It will become 454636.
:
:
: I have almost 8 columns stored social security numbers.
: Please show me how to fix the problem.
:
: Thank you
: Loi