Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
cretesupplies
 
Posts: n/a
Default HOW TO CONVERT NUMBER TO TEXT

Hello there.I've been dealing with a humongously troubling case.

I have something like 50.000 cells in Excel with numbers in them.The problem
is that i want these numbers written in letters.
For instance where the number "1245" is i want to convert it to : "one
thousand two hundrend fourty five" .

Is there any way that i can do all this conversion process automatically ???
Can i do it with Word maybe or any other software?
Please help me with this one!!!!

Thank you in advance
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default HOW TO CONVERT NUMBER TO TEXT

http://xldynamic.com/source/xld.xlFAQ0004.html


--
Kind regards,

Niek Otten

"cretesupplies" wrote in message
...
Hello there.I've been dealing with a humongously troubling case.

I have something like 50.000 cells in Excel with numbers in them.The problem
is that i want these numbers written in letters.
For instance where the number "1245" is i want to convert it to : "one
thousand two hundrend fourty five" .

Is there any way that i can do all this conversion process automatically ???
Can i do it with Word maybe or any other software?
Please help me with this one!!!!

Thank you in advance



Reply
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
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 to COnvert text string to number timtak Excel Discussion (Misc queries) 3 June 4th 05 04:57 AM
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
Convert Numeric into Text Monty Excel Worksheet Functions 0 December 18th 04 09:25 PM


All times are GMT +1. The time now is 09:15 PM.

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

About Us

"It's about Microsoft Excel"