display figures in words

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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).

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
I missed that he was trying to do this in Excel, which I think is
understandable given that this is a Word NG.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
Back
Top