SSN as number with all 9 digits

[jbutzer72]

How can I get a SSN to display and be formatted as a number but show all digits.

I used a formula =LEFT(I2,3)&MID(I2,5,2)&MID(I2,8,4) to pull it into a cell with all digits but when I copy and paste it converts to text.

If I convert to number, it takes out the 0's at the beginning and I need the 0's to be there.

HELP PLEASE

[Speshul]

Try this:

=TEXT(LEFT(I2,3)&MID(I2,5,2)&MID(I2,8,4),"000000000")


Or even easier,

=SUBSTITUTE(G5,"-","")


Also, you can change the cell format of the cell you are copying to and use a custom format of 0000000