Mask in Excel 2000

I am trying to create a Mask in Excel for entering Socia Security numbers.  I formatted the cell as
###-##-###
This works fine except when the first number is a Zero.  Excel drops the leading zero so when I enter
011-11-1111
I get
11-11-1111
Is there any way I can get Excel to keep the leading Zero?

Thanks
lariveeAsked:
Who is Participating?
 
antratConnect With a Mentor Commented:
Hi larivee

All you have to do is format the cell as Special>Social Security Number or if no calculations are needed from the number format it as Text.

Antrat
0
 
tureCommented:
larivee,

I'm not at all sure that this will work, but... you could try to substitute the #'s with zeros. Like this:
000-00-000

Ture Magnusson
Karlstad, Sweden
0
 
lariveeAuthor Commented:
Thank you.  Worked out just fine.
0
All Courses

From novice to tech pro — start learning today.