Guests - If You want access to member only forums on FM. You will gain access only when you Sign-in or Sign-Up on Fishing Minnesota.

It's easy - LOOK UPPER right menu.

  • Announcements

    • Rick

      1st Please Post Your Fishing Report - Then Join the NEW - Private Fishing Report Clubs   01/24/2018

      Private Fishing Report Clubs - Click Here - Post Your Fishing Report Before Joining
      1st, be sure you post a fishing report in the forums, then ask to join after you post a fishing report in your area forum. The Private Fishing Report Clubs are where folks can share private fishing information with club members who have proven they know what's going on. Fishing Report Clubs Link also in Menu above. Apply to become a member today, while it's still easy. 
  • RECEIVE THE GIFTS MEMBERS SHARE WITH YOU HERE...THEN...CREATE SOMETHING TO ENCHANT OTHERS THAT YOU WANT TO SHARE

    You know what we all love...

    When you enchant people, you fill them with delight and yourself in return. Have Fun!!!

  • 0
Sign in to follow this  
Whoaru99

MS Access / Excel experts?

Question

Whoaru99

Normally I can figure out most of the stuff I need to do, but in this case I'm stumped.

I have several linked MS Access tables that I query and then export to Excel. Several of the columns that are exported are dates. In Excel I need to change the date format from mm/dd/yyyy to dd-mm-yyyy.

The problem I'm having is that for three of the four date columns, I can merely change the column/cell format and the date formats change, but on the fourth column, the only way I can get the date to change format is to change the column/cell format THEN click into a cell, hit "enter", and only then the date format changes.

What am I overlooking??

Share this post


Link to post
Share on other sites

4 answers to this question

Recommended Posts

  • 0
huntingislife

Hmmm, I am not quite sure. It appears it should just work like the other 3 columns. Is the data highlighted when you change the format?

Did you try this? : Get the first cell in the correct format and then click and hold down the lower right corner of the first cell(when you get the black + sign) and just drag down to the bottom of your data. That should change the format of the other cells to the format of the first cell.

Good Luck

Share this post


Link to post
Share on other sites
  • 0
Whoaru99

Yeah, I just select/highlight the whole date columns and then change the cell formatting. Three of the four change no problem. Nothing seems to change the format of the dates in the fourth column until I select the cell, click the cursor into the cell, and then hit enter to exit the cell. As soon as I exit the cell using the enter key, the format changes.

Also, if it change the date value in any of cells that would not reformat, the new entered value takes on the desired format.

It's like somehow the format is locked on the data in that column.

I've tried changing to date serial number/value and back again, nothing seems to work...

Don't recall if I've tried to drag the format, but I'll give that a shot Monday morning.

Share this post


Link to post
Share on other sites
  • 0
huntingislife

Another thing you could try is to insert a new blank column next to the 4th column and then copy and paste the 4th column into it. But instead of just pasting it, select "paste special" and then "values". This will get rid of anything that the format might be referencing. Then you could format the new column and delete the old one.

Share this post


Link to post
Share on other sites
  • 0
wayne123

I would compare the formats of the columns in Access and see if there is any difference. I am assuming that you are importing into a blank Excel spreadsheet if not check the format of the columns before you import the data. Also try the format painter. It is the icon with the paint brush.

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.
Sign in to follow this  



  • Your Responses - Share & Have Fun :)

    • osok
      Been a brutal hard water season for me as well, figured it was a continuation of my fall fishing luck. 
    • Wanderer
      Thanks guys.  I checked out Modis for ice coverage and Navionics to help understand how things are laid out.  Knowing what areas certain fish prefer and those typical depths is a big plus.
    • urbaniceteam
      My wife and I are hoping to get up to Mille Lacs this Saturday and spend the night on the ice.  Does anyone have any last minute availability?  All the resorts I've contacted are booked. Thanks!
    • Borch
      Lots of nice fish!  Central Mn is cranking out some nice panfish.
    • eyeguy 54
      I did till about 2 then just had to go for a bit. LOL 
    • IceHawk
      Nice fish guys. Royce doesn't look like you took the day off 
    • IceHawk
      Great Idea Rick 
    • Borch
      A plus is that the forecast is for a much nicer day Saturday.
    • Tom Sawyer
      Thanks for your work guys! You were showin' some serious team spirit being out there today. I would have helped but I had a few appointments today I couldn't reschedule. I know I'm available Friday to do any last day scouting/fine tuning....
    • IceHawk
      Definitely a grind out prefishing cats today for the gathering.  Weather made it to tough but I Jeff  and his brother pushed through the elements to try and find a few active schools .   Locating the schools were tough took a pile of holes and the augers got a workout for sure,  but fortunately  we did find a couple active schools. Jeff and his brother found a few on one lake and I found a decent school on another lake. The good news was that both schools were cruising shallow flats in both locations and about the same depths. Great news as this is a good indication they are feeding on these flats.   Amazeingly both schools were found on a inside corner. Bingo looks like we have a pattern formed. We iced and marked  a fair number of cats in both locations so things are looking good for Saturday. Plus is we added a few for the fish fry already  Jeff I'll keep plugging away out there hopefully I can dial them in even more I have a hunch there are a few more close by where we ended. 
  • Share & Have Fun