Hi,

i tried the spellnumber function which i get from microsoft support. It
works.

However,
If i want it to be in a particular format, can somebody tell me how to
make adjustment to the function?

I need the function to display something like this as a result

$52.25 displayed as "DOLLAR Fifty Two AND CENTS Twenty Five only.
(Noted the location of "Dollar" and the words "and cents")

$4.00 displayed as Dollar Four ONLY

$0.30 displayed as Thirty CENTS ONLY

All this three conditon must apply to the adjusted funtion..

Thanks..


--
suh4ila
------------------------------------------------------------------------
suh4ila's Profile: http://www.excelforum.com/member.php...o&userid=35966
View this thread: http://www.excelforum.com/showthread...hreadid=557562