ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   CONVERT NUMERICAL DIGIT IN TO WORDS (CURRENCY) (https://www.excelbanter.com/excel-worksheet-functions/214099-convert-numerical-digit-words-currency.html)

ALLIED

CONVERT NUMERICAL DIGIT IN TO WORDS (CURRENCY)
 
Hi,


Well this ragav from ALLIED i just want to know is there any tool in
MS-EXCEL which can convert NUMERICAL digit (numbers ) in to words when
applied .

If it is kindly let me know about that which can be very helpful my work.


Thanking you,

Ragavendra.M

Niek Otten

CONVERT NUMERICAL DIGIT IN TO WORDS (CURRENCY)
 
Look he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"ALLIED" wrote in message
...
Hi,


Well this ragav from ALLIED i just want to know is there any tool in
MS-EXCEL which can convert NUMERICAL digit (numbers ) in to words when
applied .

If it is kindly let me know about that which can be very helpful my work.


Thanking you,

Ragavendra.M



Gary''s Student

CONVERT NUMERICAL DIGIT IN TO WORDS (CURRENCY)
 
with a single digit in A1:
=CHOOSE(A1+1,"zero","one","two","three","four","fi ve","six","seven","eight","nine")

--
Gary''s Student - gsnu200820


All times are GMT +1. The time now is 05:47 AM.

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