transposing an array converts dates into numbers
 

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

transposing an array converts dates into numbers
 

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

transposing an array converts dates into numbers
 

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

transposing an array converts dates into numbers
 

Hi


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


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


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