| 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) | |||
Linear Mode
