View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default How to convert FIGURES in one column to WORDS in another column?

See:

XL2000: How to Convert a Numeric Value into English Words
http://support.microsoft.com/default...N-US;Q213360&;

and:

XL: How to Convert a Numeric Value into English Words
http://support.microsoft.com/default...N-US;q140704&;


--
Gary''s Student


"Shashank Virkar" wrote:

I want to get the amounts put in one column in "Figures" to appear it in
another column in "Words" . Is it possible in Excel ? See below to have a
clear idea about what I am saying.

Example-
USD:1,013,566.38 (in Column A) to Appear As "USD:One Million Thirteen
Thousand Five Hundred Sixty-six & Cents Thirty-eight only"

Please Guide, if anybody can.