ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   converting a number to English text ( not to Baht) is needed (https://www.excelbanter.com/excel-worksheet-functions/44661-converting-number-english-text-not-baht-needed.html)

Chandana Geeganage

converting a number to English text ( not to Baht) is needed
 
I need to convert numbers in to text regularly in Excel. I found a inbuilt
function for this purpose in excel 2003. But unfortunately it converts
numbers to baht text which I cannot understand and also not useful for my
work. If you can help on this matter, that will be great. I suggest to add a
function for this.

Thank you

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

Lowkey

From Excel help:

On the Microsoft Windows Start menu, point to Programs, point to Microsoft
Office Tools, and then click Microsoft Office XP Language Settings.
In the Display menus and dialog boxes in box, click the language you want.

On the User Interface tab, do one of the following:
Change the user interface language

Change the Help language


"Chandana Geeganage" wrote:

I need to convert numbers in to text regularly in Excel. I found a inbuilt
function for this purpose in excel 2003. But unfortunately it converts
numbers to baht text which I cannot understand and also not useful for my
work. If you can help on this matter, that will be great. I suggest to add a
function for this.

Thank you

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions



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

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