Auto spelled number
 

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

Auto spelled number
 

Have a look at this:

http://support.microsoft.com/default...b;en-us;213360

Best regards

John

"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

Auto spelled number
 

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

Auto spelled number
 

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