PDA

View Full Version : Stupid question, 0 and -



doctortt
11-29-2012, 01:18 PM
Can someone shed me some light?

One row is showing 0 while the other is -

I have no idea. I already used Format Painter to make sure the format is the same. I want all 0 to be -

magelan
11-29-2012, 01:25 PM
provide workbook as sample.

Aflatoon
11-30-2012, 05:01 AM
I suspect the value displaying as 0 is not actually 0 - it contains some decimal part.

doctortt
11-30-2012, 07:25 AM
Thanks a lot. You're right - it's the decimals.