Thread: zeros
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default zeros

So what formatting do you think the cells do have?
Tell us what format the cell has for each of your results
0.00
(0.00)
-

I would bet that they are NOT all the same format.
--
David Biddulph


"Flipper" wrote in message
...
Why, in the result of a formula, does "0" sometimes appear as 0.00,
(0.00),
or -? The formula and the formatting on all cells is the same and is a
simple formula like A4-B4.
Thanks
--
Allan