ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how to converting numers to text (https://www.excelbanter.com/excel-worksheet-functions/169685-how-converting-numers-text.html)

Anil showreddy

how to converting numers to text
 
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

Mike H

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


Bob Phillips

how to converting numers to text
 
See http://www.xldynamic.com/source/xld.xlFAQ0004.html

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Anil showreddy" wrote in message
...
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





All times are GMT +1. The time now is 04:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com