format a column
 

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.

format a column
 

How about selecting the column and EditReplace

What: . (period)

With: nothing

Replace all.


Gord Dibben MS Excel MVP

On Mon, 5 Feb 2007 10:57:01 -0800, Lonnie
wrote:

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.

format a column
 

Use ctl H put a . on top and nothing on bottom.
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Lonnie" wrote:

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.

format a column
 

Hi Lonnie

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

--
Regards

Roger Govier


"Lonnie" wrote in message
...
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.