View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
conman
 
Posts: n/a
Default How to convert a number to text

An interesting question,
(copy)

Can anyone please tell me how to convert a value to text. e.g. $123 in cell A1
and in cell A2 I want the output like "One Hundred and Twenty Three Dollars".
What formula should I type in cell A2?