Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Ankeny, Iowa, USA
    Posts
    344
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Date Format (Excel 2002)

    In a database, one of my columns is in a date format (mm/dd/yy). In another worksheet I pull in this cell that contains the date by using a formula (=database!$A$2). I formatted this cell to also be a date format of mm/dd/yy and everything worked dandy as I've done this a million times. Next I added to the formula the following

    =database!$A$2&" UPS Charges"

    Now the date has translated itself into a number as opposed to the date that I need... for example, I'd like to see it read as the following:

    6/21/06 UPS Charges

    As usual, any help will be greatly appreciated!
    Thank you!
    LJM

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Date Format (Excel 2002)

    Try

    =TEXT(database!$A$2,"m/d/yy")&" UPS Charges")

    or simply use

    =database!$A$2

    and set a custom format

    m/d/yy" UPS Charges"

  3. #3
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Ankeny, Iowa, USA
    Posts
    344
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Date Format (Excel 2002)

    Thanks Hans!
    LJM

Posting Permissions

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