format a column

L

Lonnie

I have a column(E) of numbers in this format (9018.90.8000)....I want to be
able to write a formula or format that will get rid of the periods.
 
G

Gord Dibben

How about selecting the column and Edit>Replace

What: . (period)

With: nothing

Replace all.


Gord Dibben MS Excel MVP
 
R

Roger Govier

Hi Lonnie

In another column enter
=SUBSTITUTE(E1,".","")
Copy down as required.
When finished, copy this Helper column and Paste Special>Values back
over column E
 
Top