Thread: Changing $ format to a written format
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default Changing $ format to a written format
You will have to use a macro. Refer

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

If this post helps click Yes
---------------
Jacob Skaria


"JGW" wrote:

Is there a formula that will take a dollar figure such as $15,231.23 in one
cell and have the written value of that cell to another? If the dollar
amount is in a1, can the result be fifteen thousand two hundred thirty one
dollars and 23/100 cents be in a2?
--
Julia
Reply With QuoteReply With Quote