View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ginny@apl
 
Posts: n/a
Default Is there a formula to change number value to the written value?

I am creating a teplate in excel and need to write a formula that takes a
number in it's currency form and converts it to the written form...much like
what you would find on a check. How do I do this?

Ex. $1000.00 converts to One Thoudand Dollars and 00/100.