View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MelissaC MelissaC is offline
external usenet poster
 
Posts: 1
Default social security numbers in Excel

I have an excel spreadsheet that currently displays social security numbers
in this format. 000-00-0000. Is there a way to change that format so only
the last five digits display? example ***-*0-0000

Thank you.