Stefan -
Have a look at the following link, it has a UDF that you can taylor to do
this:
http://www.xldynamic.com/source/xld.xlFAQ0004.html
--
Regards,
Dave
"Stefan White" wrote:
Can you display numbers as words in excel (eg. 10 as ten)?
Basically I have standard forms in Excel that require a number both in
numerics and in words, like a cheque. Ideally I would like to type in the
number and for another cell to = this number but display it in words. Is this
possible using Excel 2000?
Thanks.