Number in words.
 

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

Number in words.
 

Hi Rahul,

Look here for several solutions:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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