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