Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default covert figure in to text

Anyboy have this function which convert figure into text format or
please give me the link.

best regards

thank you
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 364
Default covert figure in to text

If number is in A1 then pu this in B1 to convert it to text
=TEXT(A1,"#")

"bmurlidhar" wrote:

Anyboy have this function which convert figure into text format or
please give me the link.

best regards

thank you

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default covert figure in to text

On Oct 3, 5:47*pm, Sheeloo wrote:
If number is in A1 then pu this in B1 to convert it to text
=TEXT(A1,"#")



"bmurlidhar" wrote:
Anyboy have this function which convert figure into text format or
please give me the link.


best regards


thank you- Hide quoted text -


- Show quoted text -


I meant to convert in to words i.e. 10000 (Ten Thousand)
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default covert figure in to text

On Oct 3, 5:47*pm, Sheeloo wrote:
If number is in A1 then pu this in B1 to convert it to text
=TEXT(A1,"#")



"bmurlidhar" wrote:
Anyboy have this function which convert figure into text format or
please give me the link.


best regards


thank you- Hide quoted text -


- Show quoted text -


I meant to convertion from number to words i.e. 10000 (Ten thousand)
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default covert figure in to text

On Oct 3, 5:47*pm, Sheeloo wrote:
If number is in A1 then pu this in B1 to convert it to text
=TEXT(A1,"#")



"bmurlidhar" wrote:
Anyboy have this function which convert figure into text format or
please give me the link.


best regards


thank you- Hide quoted text -


- Show quoted text -


convertion from figure to words i.e. 10000 (Tendthousand)


  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default covert figure in to text

Well, with 3 posts of the same message that's thirty thousand so far. :-(

http://support.microsoft.com/kb/213360
http://www.xldynamic.com/source/xld.xlFAQ0004.html
http://www.ozgrid.com/VBA/ValueToWords.htm
--
David Biddulph

"bmurlidhar" wrote in message
...

convertion from figure to words i.e. 10000 (Tendthousand)


On Oct 3, 5:47 pm, Sheeloo wrote:
If number is in A1 then pu this in B1 to convert it to text
=TEXT(A1,"#")


"bmurlidhar" wrote:
Anyboy have this function which convert figure into text format or
please give me the link.




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
Covert Text String Data Pat Excel Worksheet Functions 1 August 13th 08 07:21 PM
covert a numeric number into Text (English U.S) Amit Excel Discussion (Misc queries) 1 June 13th 08 05:28 AM
Covert text to Hyperlink Eli Kedar Excel Worksheet Functions 2 March 13th 06 01:50 PM
how to convert numerical figure into text ckchuah Excel Worksheet Functions 1 August 23rd 05 02:40 PM
change figure to text randall1000 Excel Discussion (Misc queries) 3 January 28th 05 03:11 PM


All times are GMT +1. The time now is 07:47 AM.

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"