Thread: HOW CAN CONVERT A NUMBER INTO TEXT E.G. 5000 TO FIVE THOUSAND
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default 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 With QuoteReply With Quote