Thanks Peo, but I have about a thousand of these entries. Is there a way of
formatting them all at once?
Mehmet

"Peo Sjoblom" wrote:

Format the numbers as dates


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Mehmet" wrote in message
...
Hi,
Sorry if this has already been answered but I couldn't find it among the
posts. I have some data that I am transposing using an array formula.
One
of the columns contains dates. When I transpose rows into columns, this
date
appears as a number. Is there anyway of making the array formula show this
as
dates? Thanks in advance.
Mehmet