transposing an array converts dates into numbers

M

Mehmet

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
 
M

Mehmet

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

Arvi Laanemets

Hi


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


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