| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW CAN CONVERT A NUMBER INTO TEXT E.G. 5000 TO FIVE THOUSAND
HOW CAN CONVERT A NUMBER INTO TEXT E.G. 5000 TO FIVE THOUSAND
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HOW CAN CONVERT A NUMBER INTO TEXT E.G. 5000 TO FIVE THOUSAND
You will have to use a macro. Refer
http://www.ozgrid.com/VBA/CurrencyToWords.htm -- If this post helps click Yes --------------- Jacob Skaria "Sachin" wrote: HOW CAN CONVERT A NUMBER INTO TEXT E.G. 5000 TO FIVE THOUSAND |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert currency to text in Excel ($2,000 to Two Thousand) | Excel Discussion (Misc queries) | |||
| convert currency to text in Excel ($2,000 to Two Thousand) | Excel Discussion (Misc queries) | |||
| how to convert the numerical to text (ie 1200 to One thousand two | Excel Discussion (Misc queries) | |||
| How do I add a zero in front of a text formatt number of 5000 reco | Excel Worksheet Functions | |||
| How to convert number in word format like (1000 i.e. One Thousand | Excel Discussion (Misc queries) | |||
Linear Mode
