Actually did not solve the problem. Now looking at the individual
socials, although the display shows 023456789, when I look at the cell
in edit mode,
if only shows 23456789, which does not help because I need to import
this data into access and the leading zero is missing.

putting the ' in front of the number, would solve the problem, but I
don't know how to automate that. with 524 employees, I can't do that in
edit mode.
Anne


--
annep
------------------------------------------------------------------------
annep's Profile: http://www.excelforum.com/member.php...o&userid=18851
View this thread: http://www.excelforum.com/showthread...hreadid=568622