Thread: How do I calculate exact difference between two dates in y,m,d.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Muhammad Javaid Hassan Muhammad Javaid Hassan is offline
external usenet poster
  
Posts: 10
Default How do I calculate exact difference between two dates in y,m,d
Thanks Pierre!, it realy works.
Regards,
Muhammad Javaid Hassan

"Pierre" wrote:


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