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. |
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. |
All times are GMT +1. The time now is 11:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com