ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   CONVERT NUMBER TO TEXT (https://www.excelbanter.com/excel-discussion-misc-queries/148274-convert-number-text.html)

adeel via OfficeKB.com

CONVERT NUMBER TO TEXT
 
Please tell me the formula to convert Number value to Text value (eg. 10,000
convert to Ten Thousand)
thanks

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200706/1


Niek Otten

CONVERT NUMBER TO TEXT
 
Look he

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


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"adeel via OfficeKB.com" <u32736@uwe wrote in message news:745dc7a2453e4@uwe...
| Please tell me the formula to convert Number value to Text value (eg. 10,000
| convert to Ten Thousand)
| thanks
|
| --
| Message posted via OfficeKB.com
| http://www.officekb.com/Uwe/Forums.a...excel/200706/1
|



Bernard Liengme

CONVERT NUMBER TO TEXT
 
Some mo
Bob Phillips' site for help on this.

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

or Bernd Plumhoff's site

http://www.sulprobil.com/html/spellnumber.html

or

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

or

http://support.microsoft.com/?kbid=213360

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"adeel via OfficeKB.com" <u32736@uwe wrote in message
news:745dc7a2453e4@uwe...
Please tell me the formula to convert Number value to Text value (eg.
10,000
convert to Ten Thousand)
thanks

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200706/1





All times are GMT +1. The time now is 08:34 PM.

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