I don't think it can be done.

BUT ... others may have some ideas.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"nowfal" wrote in
message ...

Hi Ragdyer,
Thanks for the reply. What you mention is below
1000. My requirement is any amount which is having cents should show
like 1000.50 and which is not having cents should be like 1000/=
I hope you got my problem.
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