Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Wellington, Wellington, New Zealand
    Posts
    378
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Valid dates formats (Office 2003)

    Hi

    I have a dialog box containing a text box used for entering a date.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Valid dates formats (Office 2003)

    It can't be a number, which is what you entered. Office doesn't know what that number represents, so it interprets it as a date serial value and converts that to the equivalent date. If you want to enter a date, you must use date delimiters valid for your regional settings, slashes, hyphens, periods, etc.
    Charlotte

Posting Permissions

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