View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GIS Tech II GIS Tech II is offline
external usenet poster
 
Posts: 3
Default Cell Formatting Removing Dashes

I am working with Excel, trying to remove dashes from Text "000-000-000-000"
but still keep zeros. The cell MUST keep all 12 digits including zeros for
it to work for me. The data is imported from a report program as delimited
text, and then I have to import the data to Access for a different program.
HELP!!!!!