You could try this on a copy of your workbook.....

Highlight the column, then Edit Replace FindWhat: - ReplaceWith:
Leave blank ReplaceAll

Vaya con Dios,
Chuck, CABGx3


"Kamron" wrote in message
...
I have to export a spreadsheet from another data base. The numbers come
over
as ##-####-##-#, and I am unable to change their format. Does anyone know
how to change this number to #########?

Thank you!