<div>
larivee,<br />
<br />
I'm not at all sure that this will work, but... you could try to substitute the #'s with zeros. Like this:<br />
000-00-000<br />
<br />
Ture Magnusson<br />
Karlstad, Sweden
</div>


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

<div>
Thank you. &nbsp;Worked out just fine.
</div>


<div>
<div class="content wysiwyg-content">
I am trying to create a Mask in Excel for entering Socia Security numbers. &nbsp;I formatted the cell as<br />
###-##-###<br />
This works fine except when the first number is a Zero. &nbsp;Excel drops the leading zero so when I enter<br />
011-11-1111<br />
I get<br />
11-11-1111<br />
Is there any way I can get Excel to keep the leading Zero?<br />
<br />
Thanks<br />

</div>
</div>


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


Mask in Excel 2000

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.