Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
Format cell to match cells below in same column | Excel Discussion (Misc queries) | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Format cell in column B based on value in the next cell (column c) | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |