Posted to microsoft.public.excel.misc

conman

Posts: n/a

How to convert a number to text

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert text strings to a code or number	MaxNY23	Excel Worksheet Functions	15	March 23rd 06 10:47 PM
Convert from number to text	sir in excel how we convert number to te	Excel Worksheet Functions	2	March 17th 06 01:49 PM
how can I convert numeric number into text	firas	Excel Discussion (Misc queries)	1	September 21st 05 07:05 PM
Formulas dealing with text data	Bagia	Excel Worksheet Functions	6	June 20th 05 10:29 PM
How do I convert a number formated as a date to text in Excel?	BrotherNov	Excel Discussion (Misc queries)	5	March 2nd 05 03:51 PM

All times are GMT +1. The time now is 03:59 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us