View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Caspar Caspar is offline
external usenet poster
 
Posts: 3
Default Currency to text

I have a column with a list of numbers in currency format (No decimal places)
i.e £168,995. Is it possible to automaticaly convert this in excel to text,
i.e. One Hundred and Sixty Eight Thousand Nine Hundred and Ninety Five
Pounds, if so how?

Thank you