Thanks to both Bob and John for your advice

Shamsul

"Bob Phillips" wrote:

See http://www.xldynamic.com/source/xld.xlFAQ0004.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ShamsulZ" wrote in message
...
I'm have been looking for a formula in Excel to automatically generate a
sentence in Excel from a number in single cell. E.g in A1 cell the no. is
100.50, I want Excel to auto generate "Dollars : One hundred and cents
fifty
only' in C1. In this way I dont have to waste my time spelled and avoid
any
mistakes.

Thanks friends