Cell Formatting Removing Dashes

[GIS Tech II]

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!!!!!

 

[Alan]

Try
=SUBSTITUTE(A1,"-","")
The cell must be formatted as text to retain the leading zeros,
Regards,
Alan.

 

[GIS Tech II]

Alan,

Thanks a million, I'm not sure why I didn't think of creating a new
column.........