I have a formula in a cell producing results:
e.g. - 40.00
e.g. - 40.25
If the result is an integer, I want it displayed as "40", not "40.00".
Hence, I would like to display:
40
40.25
Is there an easy way to do this, either through formatting the cell, or
a formula tweak?
Thanks.
- jim
--
James C
------------------------------------------------------------------------
James C's Profile:
http://www.excelforum.com/member.php...o&userid=12114
View this thread:
http://www.excelforum.com/showthread...hreadid=475988