| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
skipping zeros
hello i have the following data:
A B C 1 0 -1000 -1000 2 0 0 0 3 100 0 100 4 0 0 0 5 0 0 0 6 0 0 0 7 200 0 200 8 300 0 300 i would like to skip the zeros and make the following : 0 -1000 -1000 100 0 100 200 0 200 300 0 300 IS THERE ANY FORMULA FOR THAT ?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reference row on another sheet skipping zeros but not skipping li. | Excel Discussion (Misc queries) | |||
| when i megre cells that begin with zeros , I lose the zeros | Excel Discussion (Misc queries) | |||
| Essbase: Text zeros to number zeros | Excel Discussion (Misc queries) | |||
| Charting zeros as non zeros | Charts and Charting in Excel | |||
| save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) | |||
Threaded Mode
