View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tim Green Tim Green is offline
external usenet poster
 
Posts: 17
Default How to show -0 as 0?

Due to the binary/decimal thing, some of my financial figures come out to -0
at that level of rounding. I am using an external provider's plug-in to
calculate the figure from an external database, so I can't use the round
function to give me 0.

Is there any way of displaying -0 as 0, but other negative values as (100),
for example?