View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kapoor kapoor is offline
external usenet poster
 
Posts: 4
Default how can convert the figures in to the word in excel

Hi,

Kindly note that to prepare excel invoices daily. I have to write the total
amount of invoice both in figures and words, right now i m manually writing
the amount in words. Is there any formula to convert the figures to words?

I had also used the command i.e. spellnumber(..) but getting the message
#NAME?, Please guide and help on the above.

Lot of thanks in advance.

Thanks & Regards

Pradeep Kapoor