LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default how to converting numers to text

Hi

Have a look here
http://www.ozgrid.com/VBA/ValueToWords.htm

If you done want the dollars and cents bit then you can delete that bit of
the code

Mike

"Anil showreddy" wrote:

can u help me in converting numbers to test

Eg: if i type 110 i want the answer like one hundreed and ten
--
Anil showreddy

 
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 to use arabic numers in excel 2003 arimala Excel Discussion (Misc queries) 1 October 22nd 07 09:01 PM
Substituting letters for numers Mike New Users to Excel 4 May 8th 07 04:41 AM
Giving numers value to selections the dude Excel Discussion (Misc queries) 1 May 16th 06 07:44 PM
Automatic Calculating % for a row of numers of the total vaule Stuart Millner Excel Worksheet Functions 1 May 3rd 06 09:57 PM
converting numbers to text and prefill text field with 0's Jan Buckley Excel Discussion (Misc queries) 2 January 20th 05 09:03 PM


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

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"