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!

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!

Hi,

Let's say the numbers are in Column A, starting in A2. Create a helper
column (B, C, or D .......) with the following formula in (B2, C2, or
D2.....), and fill down the column.

=--SUBSTITUTE(A2,"-","")

Copy that helper column and do a "Paste Special" -- "Values" on the
original column (i.e., Column A). This will replace the original format with
the desired format. Now you can get rid of the helper column.

If this helps, please give a feedback by clicking "Yes".

Regards,
B. R. Ramachandran




"Kamron" wrote:

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!