Many thanks to Andy and Sheila D. Your suggestions helped tremendously

Regards

Ron




"Andy" wrote:

Hi

You could use a helper cell alongside your existing date with
=TEXT(A2,"yyyymmdd")
in it.

Andy.

"RC" wrote in message
...
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.