ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   covert figure in to text (https://www.excelbanter.com/excel-discussion-misc-queries/204894-covert-figure-text.html)

bmurlidhar

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

Sheeloo[_2_]

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


bmurlidhar

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)

bmurlidhar

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)

bmurlidhar

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)

David Biddulph[_2_]

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.






All times are GMT +1. The time now is 12:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com