Adding a leading zero to a SSN
I think so--but I've been wrong before.
"I need a have a formula that will add a zero to the begging (sic) of a 8
character string."
Stefi wrote:
Hi Dave,
No, I meant eight 0's, because cflarida wanted leading zeros up to 8
character length. In case of nine 0's string e.g. 1234567 would be displayed
as 001234567 and it's 9 character length instead of 8 character long
01234567. Did I misunderstand something?
Regards,
Stefi
Dave Peterson ezt *rta:
I bet you meant nine 0's.
Or even Format|cells|number tab|special category|social security number
(to get 000-00-0000)
Stefi wrote:
Apply custom format on cell A1, enter format code 00000000 (eight 0 digits)
Regards,
Stefi
â ezt Ã*rta:
I am pulling SSN out of one of my systems and putting it in excel.
When it comes out of my AS/400 it does not have a leading zero if
needed. I need a have a formula that will add a zero to the begging
of a 8 character string if needed but if is in already 9 characters
long I need to leave it alone.
A1 has the SSN in text, which is how I need it. I need A2 to have the
SSN with the leading zero if not 9 characters long.
--
Dave Peterson
--
Dave Peterson
|