Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Richland, Washington, USA
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Uppercase Date Format (2002 SP-2)

    I'd like to create a custom number format for dates that would produce an upper case month; e.g., 02DEC03. The closest I can get without converting the cell contents to text (=UPPER(TEXT(NOW(),"mmdddyy"))) is the "Title" case (03Dec03). Anyone know how I can get 'DEC' instead of 'Dec' and still have a number in the cell?

    It sure would be nice if the date formatting for numbers was case sensitive (i.e., ddmmmyy produces 02dec03, ddMmmyy produces 02Dec03, ddMMMyy produces 02DEC03, etc.)...

    Thanks.

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Uppercase Date Format (2002 SP-2)

    Tom, you have a problem. See <!post=this,293802>this<!/post> thread.
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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