0 number

L

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
 
I

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
 
L

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
 
Top