Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format zeros
I have field that have numbers with zero,s like this 0002764357000 i would
like to format the column so that the zeros before or after any number are not shown does anyone know how to do this? thanks octet |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format zeros
=SUBSTITUTE(A1,0,"")
"octet" wrote: I have field that have numbers with zero,s like this 0002764357000 i would like to format the column so that the zeros before or after any number are not shown does anyone know how to do this? thanks octet |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format zeros
hi Mike i am new to Exel do i insert this int condistional formating?
"Mike" wrote: =SUBSTITUTE(A1,0,"") "octet" wrote: I have field that have numbers with zero,s like this 0002764357000 i would like to format the column so that the zeros before or after any number are not shown does anyone know how to do this? thanks octet |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format zeros
The formula will remove internal zeros as well as leading and trailing zeros.
-- Gary''s Student - gsnu200777 "Mike" wrote: =SUBSTITUTE(A1,0,"") "octet" wrote: I have field that have numbers with zero,s like this 0002764357000 i would like to format the column so that the zeros before or after any number are not shown does anyone know how to do this? thanks octet |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format zeros
Those are either numbers formatted with leading zeros or text.
If the latter, to get rid of the leading zeros, re-format as General, copy an empty cell and select range of numbers and editpaste specialaddokesc. Now to deal with the trailing zeros...........do they all have 3 trailing zeros? If so, enter 1000 in an empty cell and as above except use the "divide" option. Gord Dibben MS Excel MVP On Thu, 3 Apr 2008 11:24:00 -0700, octet wrote: I have field that have numbers with zero,s like this 0002764357000 i would like to format the column so that the zeros before or after any number are not shown does anyone know how to do this? thanks octet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
leading zeros in text format | Excel Discussion (Misc queries) | |||
leading zeros fall off in csv format. | Excel Discussion (Misc queries) | |||
Format cell so zeros don't dissappear? | Excel Discussion (Misc queries) | |||
Format a cell to keep leading zeros. | New Users to Excel | |||
save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) |