Number in words.

[RAHUL]

When I enter the formula i.e. =Bahttext it comes in different language i.e.
not come in English after changing the setting in control pannel.

e.g. if amount is 1500/- (One thouse five hundred) it comes in
(หนึ่งพันห้าร้อยบาทถ้วน) which i want the same in English.

Please suggest for the same.

 

[Niek Otten]

Hi Rahul,

Look here for several solutions:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| When I enter the formula i.e. =Bahttext it comes in different language i.e.
| not come in English after changing the setting in control pannel.
|
| e.g. if amount is 1500/- (One thouse five hundred) it comes in
| (??????????????????????) which i want the same in English.
|
| Please suggest for the same.
| --
| Reagrds,
|
| Rahul