transposing an array converts dates into numbers

[Guest]

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

 

[Peo Sjoblom]

Format the numbers as dates


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Guest]

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

 

[Arvi Laanemets]

Hi

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

Sure it is! Select the range and format it. Or is there something you didn't
us say about?