Sometime ago I asked about having a column a numbers (soc sec numbers) and
one more numbers in them, making a total of 10 numbers. I wanted to strip the
last digit.

I was helped by using the following function: =left(a1,9), then I was
instructed to copy the whole column where the 9 digits were and paste them
specialvalue to another column. That way I have the value and not the
formula. However, when I want to format the resulting value column to
represent a social security number, it does not accomplish it.

I have two problems:

When stripping the last digit the function LEFT does not take in account a
left zero (leading zero) and,

How can I format the resulting number to represent a social security number?

TIA

Hernan