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

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

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

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

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