cell formattiing

[Kamron]

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!

 

[clr]

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

 

[B. R.Ramachandran]

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