=TEXT(A1,"dd/mm/yy") or whatever other format you want.
--
David Biddulph

"leonperrins" wrote in message
...
Right, thanks for that.
Now, I have copied the table into an Access database and the "Excel"
numbers
have appeared not the dates.
Can I converts these numbers to dates in Access or what can I do to
transfer
the dates themselves?

"JMay" wrote:

I believe the Ctrl+ ' or the Ctrl + D replicates **ONLY THE VALUE **
Of the Cell ABOVE, it does not include the formatting (of the above
source).


"leonperrins" wrote in message
:

I am running XP Pro+SP2 and Excel 2002.

Why do I get a number when I try to copy the date from the cell above
into
my working line by hitting Ctrl + '.