Thread: Formatting SSNs
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cheri
 
Posts: n/a
Default Formatting SSNs

I'm having difficulty with a spreadsheet and socials - I need to format them
so the leading zeros remain and the hyphens go away. I was given a concate
formula but in order to make that work I have to put it into the spreadsheet
and I can't use the column where it goes. The parameters are assigned for
uploading a flat file into our system. Can someone help me with low level
directions. I'm literate but not that literate.
Cheri