display figures in words

[Raj1978]

Hi Guys,

Plzzzzzz help me out on how to convert figures to words in Excel like for
eg: i want the value "2354" to be displayed as "Two thousand Three hundred
fifty four only". Is there a formula for this??

Awaiting a qucikkkkkk replyyyyy

Rajesh

 

[garfield-n-odie]

See http://support.microsoft.com/?kbid=213360 "How to convert a
numeric value into English words in Excel".

 

[Suzanne S. Barnhill]

If your numbers are produced by a field, you can add the \*CardText
formatting switch. See the Help topic "Format (\*) field switch" for other
options (including capitalization).

 

[garfield-n-odie]

I don't think \*CardText works in Excel.

 

[Suzanne S. Barnhill]

I missed that he was trying to do this in Excel, which I think is
understandable given that this is a Word NG.