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.
I might have missed a guess, but here are the ones that I noted:
JerkinLips – March 27th, then April 7th
Brianf. – March 28th
Bobberwatcher – April….
MikeG3Boat – April 10th
SkunkedAgain – early April, then April 21st
Definitely a tough year for guesses, as it seemed to be a no-brainer early ice out. Then it got cold and snowed again.
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??
Link to comment
Share on other sites
4 answers to this question
Recommended Posts