Figures to words

[RedRobin]

Is there an excel formula that will take the contents of a cell in numbers
and convert it into words?

Example 1565 to one 'thousand five hundred and sixty five'

M

 

[Bernard Liengme]

Can be done with VBA. See
Bob Phillips' site for help on this.
http://www.xldynamic.com/source/xld.xlFAQ0004.html

or Bernd Plumhoff's site
http://www.sulprobil.com/html/spellnumber.html
best wishes