Perhaps

=IF(MOD(A1,1)<0,TEXT(A1,"0000.00")&" metres",TEXT(A1,"0000")&"/=
metres")

will suit your needs, but the question does seem to have drifted a
little from metres to cents.



nowfal Wrote:
Hi Ragdyer,
Thanks for reply. I also thinking that way. Hope
somebody will have some new tricks.
nowfal


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