| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
NumberFormat for small non-zero numbers?
I have a column that subtracts two other columns and is displayed as currency. If the other two columns are "close", this column shows zero.
Most of the rows will be zero, and it's the non-zeros that are "interesting". So I've put in a NumberFormat to eliminate the zero, so it's a blank. However, in many cases the number is not zero, but some very small value... 0.0000000000123 Is there anything I can do to make these fall into the zero format as well? I could round it, but is there an easier way? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cells print so small I cannot read numbers. How do I fix? | New Users to Excel | |||
| Sorting numbers in a row from small to large | Excel Discussion (Misc queries) | |||
| using linest with very small numbers | Excel Worksheet Functions | |||
| setting numberformat for -ve numbers | Excel Programming | |||
| Small font on row & column numbers - wierd | Excel Discussion (Misc queries) | |||
Threaded Mode
