How do I show number with spelling word example "89" as " eighty .
 

How do I show number with spelling word example "89" as " eighty nine".

How do I show number with spelling word example "89" as " eighty .
 

=ROUNDDOWN(89,-1).

--- "Currency number spelling" wrote:
How do I show number with spelling word example "89" as " eighty nine".

How do I show number with spelling word example "89" as " eighty .
 

Hi,

Download and install the more frunc addin from
http://xcell05.free.fr/morefunc/english/index.htm and then use the
NBTEXT(cell_ref) function.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Currency number spelling" <Currency number
wrote in message
...
How do I show number with spelling word example "89" as " eighty nine".