How to convert a number to text

Giganews Newsgroups
Subject: How to convert a number to text
Posted by:  conman (kcusf…@ppmes.spineless.org)
Date: Wed, 07 Jun 2006

An interesting question,
(copy)
>>
>> Can anyone please tell me how to convert a value to text. e.g. $123 in cell A1
>> and in cell A2 I want the output like "One Hundred and Twenty Three Dollars".
>> What formula should I type in cell A2?

Replies