Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Feb 2010
    Location
    Indiana
    Posts
    25
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Can't make date format match downloaded data

    I download my credit card charges from the Chase Bank website into my 2007 Excel spreadsheet. The date for each entry appears in the format 07/22/2015, which I like.

    I add other information to the spreadsheet but cannot duplicate this date format on my data. Using 'format painter', I tried to copy the Chase date format to my other date cells. It doesn't work. The date appears as a date number--not a date with the 07/22/2015 format.

    I checked how the Chase date was formatted and it uses a custom format '##,###,##0.00'. I tried typing the custom format assigned to my date cells but it still just gave the date number.

    Does anyone know how to do this in Excel 2007?

    Thanks for your help.

    Planckster

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,919
    Thanks
    152
    Thanked 746 Times in 678 Posts
    Try: Right click cell(s) > Format cells > Custom > enter mm/dd/yyyy in the Type box > OK

    HTH,
    Maud

  3. The Following User Says Thank You to Maudibe For This Useful Post:

    planckster (2015-09-27)

  4. #3
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,950
    Thanks
    61
    Thanked 1,104 Times in 1,027 Posts
    That format doesn't look like a data format to me. Can you give us an example of the number shown in the field you want to format?

    cheers, Paul

  5. #4
    Lounger
    Join Date
    Feb 2010
    Location
    Indiana
    Posts
    25
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Maudibe,

    That worked! I appreciate your help and time.

    planckster

  6. #5
    5 Star Lounger Lugh's Avatar
    Join Date
    Jun 2010
    Location
    Indy
    Posts
    828
    Thanks
    209
    Thanked 106 Times in 93 Posts
    Quote Originally Posted by planckster View Post
    I ... cannot duplicate this date format on my data. ... it still just gave the date number.
    Excel is a truly excellent piece of software, but one of its glaring faults is with date formatting. I use Excel 2013 and it's still a real pain to get imported data to display dates properly.
    Quote Originally Posted by Paul T View Post
    That format doesn't look like a data format to me.
    Me neither, maybe it's a port from mainframe data because it's really messed up.

Posting Permissions

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