I have to cut n paste a series of rows from Access to Excel.
In the access database, there is a date field like 26/08/2006.
It pastes into Excel OK
I then want to change the way it looks to a format yyyymmdd. It needs to
bejust a text cell and not date type.
However - I cannot get it to lose its access format and consequently can't
get the data in the way I want it.
Any ideas please.