Results 1 to 5 of 5

Thread: Spell a Date out in Words

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 02-25-2012, 03:12 AM #2
    Haseeb A
    Haseeb A is offline
    Junior Member Haseeb A's Avatar
    Join Date
    Apr 2011
    Posts
    21
    Rep Power
    0
    Nice one Rick as usual

    A minor bug, for the period 1/1/1900 - 2/29/1900 shows a day prior.

    eg:

    1/1/1900 & 2/29/1900, shows "Thirty-first of December, One Thousand Eight Hundred Ninety-Nine" & "Twenty-eighth of February, One Thousand Nine Hundred" respectively.

    Based on your logic, I think we could also use it by native formulas, with help of 2 lookup tables.


    Regards,
    Haseeb A
    Attached Files Attached Files
    Worksheet Functions
    Excel 2003 to Excel 2007 command reference guide
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Number to Words (Rupees)
    By vishwajeet_chakravorty in forum Excel Help
    Replies: 8
    Last Post: 02-24-2014, 09:26 PM
  2. Lookup Start Date And End Date Range For Specific Date Using Formula
    By mahmoud-lee in forum Excel Help
    Replies: 5
    Last Post: 06-15-2013, 12:40 PM
  3. Replace Incorrect Date In Cell To Another Valid Date
    By DARSHANKmandya in forum Excel and VBA Tips and Tricks
    Replies: 2
    Last Post: 03-21-2013, 09:27 PM
  4. Spell a Date out in Words
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 6
    Last Post: 04-08-2012, 12:19 PM
  5. Number to Words (Rupees)
    By sa.1985 in forum Excel Help
    Replies: 2
    Last Post: 12-16-2011, 08:57 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules