Converting Numbers to description in words

Originally Posted by vvraj

Hi All,

How do you convert a number (including decimal numbers) into its respective descrition in words.

eg: we key in say : 120 in one column and it returns "One Hundred And Twenty" in another column.

Is there a function and/or macro for this.

Thanking in advance.

vvraj

HI,

see http://support.microsoft.com/kb/213360

---

Here's another option here.

Converts a positive number into spelled-out text, in several languages

http://xcell05.free.fr/english/morefunc/nbtext.htm