View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bd420 bd420 is offline
external usenet poster
 
Posts: 1
Default Input mask for changing a numeric to a Zero

I have SSN information (Nine digits) that I would like to be able to
mask the first 5 digits to Zeros. Simply put, I need this SSN
(123456789) to be masked to (000006789). That's all I need, and I
apologize for not finding my answer within this group as I'm really
pressed for time.

Thank You,

bd.