| 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 | |||
Linear Mode
