| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Zero showing as a negative number
I have a spreadsheet where zeroes are showing as a negative number. In the spreadsheet this is how it looks (0.00). What can I do to correct this so zeroes are not showing as negative? Thanks!! -- Missygal ------------------------------------------------------------------------ Missygal's Profile: http://www.excelforum.com/member.php...o&userid=33200 View this thread: http://www.excelforum.com/showthread...hreadid=530190 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Zero showing as a negative number
It's because it is negative, you are displaying a number format with only 2
decimals so the value must be less than or equal to -0.004, test this, change the format to general and you'll see what the real value is if you format -0.004 as 0.00_);(0.00) it will display as (0.00) -- Regards, Peo Sjoblom http://nwexcelsolutions.com "Missygal" wrote in message ... I have a spreadsheet where zeroes are showing as a negative number. In the spreadsheet this is how it looks (0.00). What can I do to correct this so zeroes are not showing as negative? Thanks!! -- Missygal ------------------------------------------------------------------------ Missygal's Profile: http://www.excelforum.com/member.php...o&userid=33200 View this thread: http://www.excelforum.com/showthread...hreadid=530190 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Zero showing as a negative number
Peter, I tried that and it just shows 0 when I switch it to General. Now what? -- Missygal ------------------------------------------------------------------------ Missygal's Profile: http://www.excelforum.com/member.php...o&userid=33200 View this thread: http://www.excelforum.com/showthread...hreadid=530190 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Zero showing as a negative number
Peo, I tried that and it just shows 0 when I switch it to General. Now what? -- Missygal ------------------------------------------------------------------------ Missygal's Profile: http://www.excelforum.com/member.php...o&userid=33200 View this thread: http://www.excelforum.com/showthread...hreadid=530190 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Zero showing as a negative number
What if you copy it and paste special into a general cell?
-- Regards, Peo Sjoblom http://nwexcelsolutions.com "Missygal" wrote in message ... Peo, I tried that and it just shows 0 when I switch it to General. Now what? -- Missygal ------------------------------------------------------------------------ Missygal's Profile: http://www.excelforum.com/member.php...o&userid=33200 View this thread: http://www.excelforum.com/showthread...hreadid=530190 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find a negative number in a range | Excel Worksheet Functions | |||
| How do I show negative number in brackets using excel? | Excel Worksheet Functions | |||
| How to make the cell or font color red if the number is negative? | Excel Worksheet Functions | |||
| Negative number formatting | Excel Discussion (Misc queries) | |||
| 2003= negative number&2004= negative number How Do I Calculate gro | Excel Worksheet Functions | |||
Linear Mode
