View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default 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