I simply copied and pasted the solution you gave in Format Cells
Number Custom Type Enter and the result was astonishing. I
experimented with different numbers and like magic it gave the desired
result each time.
You have been a great help David and I am deeply obliged.
-*Kindly accept my heartfelt THANKS.*-


--
keje1010
------------------------------------------------------------------------
keje1010's Profile: http://www.excelforum.com/member.php...o&userid=30680
View this thread: http://www.excelforum.com/showthread...hreadid=503430