Yes, exactly right formula. This is why this forum seems to be the best.
thanks to
Bryan Hessey, and all those help early.
the corrected formula is as
=IF(MOD(a1,1)<0,TEXT(a1,"0.00")&" ",TEXT(a1,"0")&"/= ")
thanks and regards
nowfal


--
nowfal
------------------------------------------------------------------------
nowfal's Profile: http://www.excelforum.com/member.php...o&userid=10003
View this thread: http://www.excelforum.com/showthread...hreadid=477776