ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Displays the number in text string (https://www.excelbanter.com/excel-discussion-misc-queries/139213-displays-number-text-string.html)

coco2112ro

Displays the number in text string
 
How can I display in a cell the value from other cell in a text string:
example:
1234 one thousand two hundred thirty four

Mladen_Dj

Displays the number in text string
 
By using UDF for converting numbers to text. One example you can find
at:

http://www.ozgrid.com/VBA/ValueToWords.htm

Regards,
--
Mladen
http://excelancije.bloger.hr

On Apr 17, 12:20 pm, coco2112ro
wrote:
How can I display in a cell the value from other cell in a text string:
example:
1234 one thousand two hundred thirty four





All times are GMT +1. The time now is 08:16 PM.

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