Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Feb 2010
    Location
    Indiana
    Posts
    21
    Thanks
    1
    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,640
    Thanks
    115
    Thanked 651 Times in 593 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,202
    Thanks
    49
    Thanked 987 Times in 917 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
    New Lounger
    Join Date
    Feb 2010
    Location
    Indiana
    Posts
    21
    Thanks
    1
    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
    627
    Thanks
    168
    Thanked 77 Times in 68 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
  •