Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Zero's show as being negative numbers
How do I format cells in a spreadsheet to not show a zero balance as being
negative, i.e (0.00)? This does not happen in all of the cells only some? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Zero's show as being negative numbers
It's because your value actually is negative. It's something like -0.00002,
which Excel rounds to (0.00). Change your formula to round the result to two decimal places. -- Regards, Fred "Jose" wrote in message ... How do I format cells in a spreadsheet to not show a zero balance as being negative, i.e (0.00)? This does not happen in all of the cells only some? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Zero's show as being negative numbers
You asked the same question 3 hours earlier and got an answer within 6
minutes. Please don't start a new thread on the same question. -- David Biddulph "Jose" wrote in message ... How do I format cells in a spreadsheet to not show a zero balance as being negative, i.e (0.00)? This does not happen in all of the cells only some? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zero's are showing up as negative numbers | Excel Worksheet Functions | |||
Making negative numbers show as zero. | Excel Discussion (Misc queries) | |||
Do not show negative numbers | Excel Discussion (Misc queries) | |||
How do I get negative numbers to show as brackets? | Excel Discussion (Misc queries) | |||
Have negative numbers show as zero | Excel Worksheet Functions |