torpido Wrote:
hi guys
ive tried to search the forum to find the answer but the search
function is not working or u can say its kinda dead slow, so forgive me
if its been asked before.
how to convert an amount(number) to text.
eg:
1234
one thousand two hundred thirty four

i tried a formula called BAHTTEXT, its supposed to do the job but the
language is diffrent, help page says i must change the reginal option
in Cp but i cant find a usefull thing there.
i also found many articals on google search saying to the cell
formating trick, but it doesnt do any thing.

Hi torpido

have a look at these

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

http://support.microsoft.com/defaul...B;EN-US;Q213360


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=397468