how to convert nos into word format say 500 to Five Hundred

[Bhalchandra]

how to convert nos into word format say 500 to Five Hundred

We have huge data containing no's, would like convert the same into word
format

Example to convert
1 One
2 two
3 three
4 four

 

[Bob Phillips]

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

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Mike H]

Try this function:-

http://wordtips.vitalnews.com/Pages/T0040_Numbers_to_Words.html

Mike

 

[Anuj]

Try the freeware download at

http://www.powerutilsnet.com/pwrutils.htm

(Check point 2 on the feature list)

The next version of this utility promises to do this better.

Anuj