Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 13
Default convert number to text

convert number to text in english
like a function bahttext() which convert number into baht text format


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 709
Default convert number to text

Naeem, have a look here,
http://www.xldynamic.com/source/xld.xlFAQ0004.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"NAEEM" wrote in message
...
convert number to text in english
like a function bahttext() which convert number into baht text format




  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15
Default convert number to text

How To Convert Currency or Numbers into English Words?

http://support.microsoft.com/kb/259663

How to convert text to numbers in Excel 2002 and in Excel 2003?

http://support.microsoft.com/kb/291047/

Hope this help, let us know!

"NAEEM" wrote:

convert number to text in english
like a function bahttext() which convert number into baht text format


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 13
Default convert number to text

http://www.xldynamic.com/source/xld.xlFAQ0004.html
have one link, shows the functions nbttext()
but i am unable to download can u please help
http://xcell05.free.fr/



"Paul B" wrote:

Naeem, have a look here,
http://www.xldynamic.com/source/xld.xlFAQ0004.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"NAEEM" wrote in message
...
convert number to text in english
like a function bahttext() which convert number into baht text format





  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 13
Default convert number to text

thanks dear


"RajKohli" wrote:

How To Convert Currency or Numbers into English Words?

http://support.microsoft.com/kb/259663

How to convert text to numbers in Excel 2002 and in Excel 2003?

http://support.microsoft.com/kb/291047/

Hope this help, let us know!

"NAEEM" wrote:

convert number to text in english
like a function bahttext() which convert number into baht text format




  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 709
Default convert number to text

Naeem, its part of the morefunc.xll, click where it says download .zip file,
986 Kb
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"NAEEM" wrote in message
...
http://www.xldynamic.com/source/xld.xlFAQ0004.html
have one link, shows the functions nbttext()
but i am unable to download can u please help
http://xcell05.free.fr/



"Paul B" wrote:

Naeem, have a look here,
http://www.xldynamic.com/source/xld.xlFAQ0004.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"NAEEM" wrote in message
...
convert number to text in english
like a function bahttext() which convert number into baht text format







  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 136
Default convert number to text

Hello,

The versions I found in the web so far do not do any parameter check, I
think.

I changed this he
http://www.sulprobil.com/html/spellnumber.html

[Check your downloaded UDF with the values I present on my homepage, I
suggest. I cannot guarantee that my UDF is error-free - but it is used
in a bank environment]

Regards,
Bernd

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert text strings to a code or number MaxNY23 Excel Worksheet Functions 15 March 23rd 06 10:47 PM
Convert from number to text sir in excel how we convert number to te Excel Worksheet Functions 2 March 17th 06 01:49 PM
how can I convert numeric number into text firas Excel Discussion (Misc queries) 1 September 21st 05 07:05 PM
Formulas dealing with text data Bagia Excel Worksheet Functions 6 June 20th 05 10:29 PM
How do I convert a number formated as a date to text in Excel? BrotherNov Excel Discussion (Misc queries) 5 March 2nd 05 03:51 PM


All times are GMT +1. The time now is 11:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"