| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Zero's are showing up as negative numbers
How can I format a cell to not show the result of a formula as being a
negative zero, ie (0.00)? This does not happen with all of the cells only some. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Zero's are showing up as negative numbers
it is probably a rounding issue
try =round(your equation,2) "Jose" wrote: How can I format a cell to not show the result of a formula as being a negative zero, ie (0.00)? This does not happen with all of the cells only some. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete zero's from numbers | Excel Worksheet Functions | |||
| Numbers turning to Zero's | Excel Discussion (Misc queries) | |||
| Showing Negative as Postive | Excel Discussion (Misc queries) | |||
| excel changing after 15th digit the numbers into zero's | Excel Discussion (Misc queries) | |||
| showing negative numbers | Excel Discussion (Misc queries) | |||
Linear Mode
