ExcelBanter - timestamp copy and paste

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - timestamp copy and paste (https://www.excelbanter.com/excel-discussion-misc-queries/105541-timestamp-copy-paste.html)

Robert

timestamp copy and paste

I copy and paste from Access to Excel. The timestamp used to show in excel
with both date and time - but now all of a sudden just shows date. I realize
i can format the cells to show - but doing this several hundred times a day
is tedious. What changed and how can i change it back?

All times are GMT +1. The time now is 03:17 PM.