Thread: How do I calculate exact difference between two dates in y,m,d.
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pierre Pierre is offline
external usenet poster
  
Posts: 193
Default How do I calculate exact difference between two dates in y,m,d

Muhammad Javaid Hassan wrote:
I need to convert amount
written in one cell in figures ($20500) in words in the next cell or any
other cell (Dollar Twenty Thousand Five Hundred Only). Is there any formula
in Excell for that.
Regards,
Muhammad Javaid Hassan



Spell out the number as follows using this add-in.

http://orlando.mvps.org/ExcelSpellNumberMore.asp

Pierre

Reply With QuoteReply With Quote