LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
ABA ABA is offline
external usenet poster
 
Posts: 9
Default How to Change Numbers to Text. ie $1.00 = one dollar

I am trying to convert Dollar amounts into written text in an excel
spreadsheet. How do I create a formula that will convert my Numbers to word
text.
i.e. $1.00 convert to One Dollar zero cents. $100.00= Convert to One
Hundred Dollars and zero cents.
--
ABA
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Change text to numbers TVC Excel Discussion (Misc queries) 2 April 2nd 08 05:42 PM
Why won't my cells change from Text to % or Numbers Ezlpo Excel Discussion (Misc queries) 3 October 3rd 06 07:00 AM
the numbers are always in text and i cant seem to change them??? neil Excel Worksheet Functions 10 December 21st 05 08:41 PM
How do i change the currency from dollar to GB pounds Imraan Rawat New Users to Excel 2 July 29th 05 03:37 AM
change numbers to text thanks Excel Worksheet Functions 6 April 19th 05 12:47 AM


All times are GMT +1. The time now is 07:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"