Change data to Date

Marcia - May 21, 2018 at 05:30 PM
 Blocked Profile - May 22, 2018 at 04:56 PM

I am copying data from Access to Excel; the data in Access is a Date, but when it is copied to Excel it is 43190. I have tried to data change text to column, obviously tried to change the column to date format...nothing works.

2 responses

Ambucias Posts 47310 Registration date Monday February 1, 2010 Status Moderator Last seen February 15, 2023 11,166
May 21, 2018 at 05:32 PM

Please, bare in mind that is a mutual aid community, all answers on the forum are provided by volunteers who give their time free to help solve issues.

Hence we request that CCM forum users show mutual respect. Therefore, when asking for assistance, please be courteous, as for elsewhere in similar circumstances in every day society when asking for help. (Usually, how would someone ask for help? i.e. please, thank you, appreciate, grateful, etc.)

Being courteous will increase your chances of getting the help you need.

Please, copy, modify and repost your message respecting the politeness charter.

We trust that you understand.

Blocked Profile
May 22, 2018 at 04:56 PM
Change the column in Excel to refelct a date after you have brought it into EXCEL! You are welcome! Next time, try to ask a question!