format a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
How about selecting the column and Edit>Replace

What: . (period)

With: nothing

Replace all.


Gord Dibben MS Excel MVP
 
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
 
Back
Top