View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default how can I convert numberic value to text in english?

See thread just before yours (OP: KVS).

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

Regards,
Stefi

€˛Function New User€¯ ezt Ć*rta:

I have try the different function to convert number to text. But still
unsuccessful. Even though I'm using the BAHTTEXT and TEXT(value,
format_text). Maybe TEXT(value, format_text) can be use, but I have no idea
what to put in "format_text".