software

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

Format the numbers as dates--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;Mehmetquot; gt; wrote in message
...
gt; Hi,
gt; Sorry if this has already been answered but I couldn't find it among the
gt; posts. I have some data that I am transposing using an array formula.
gt; One
gt; of the columns contains dates. When I transpose rows into columns, this
gt; date
gt; appears as a number. Is there anyway of making the array formula show this
gt; as
gt; dates? Thanks in advance.
gt; Mehmet
Thanks Peo, but I have about a thousand of these entries. Is there a way of
formatting them all at once?
Mehmet

quot;Peo Sjoblomquot; wrote:

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

Hiquot;Mehmetquot; gt; wrote in message
...
gt; Thanks Peo, but I have about a thousand of these entries. Is there a way
gt; of
gt; 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.laanemetslt;atgt;tarkon.ee )gt; Mehmet
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt;gt; Format the numbers as dates
gt;gt;
gt;gt;
gt;gt; --
gt;gt;
gt;gt; Regards,
gt;gt;
gt;gt; Peo Sjoblom
gt;gt;
gt;gt; nwexcelsolutions.com
gt;gt;
gt;gt;
gt;gt; quot;Mehmetquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hi,
gt;gt; gt; Sorry if this has already been answered but I couldn't find it among
gt;gt; gt; the
gt;gt; gt; posts. I have some data that I am transposing using an array formula.
gt;gt; gt; One
gt;gt; gt; of the columns contains dates. When I transpose rows into columns, this
gt;gt; gt; date
gt;gt; gt; appears as a number. Is there anyway of making the array formula show
gt;gt; gt; this
gt;gt; gt; as
gt;gt; gt; dates? Thanks in advance.
gt;gt; gt; Mehmet
gt;gt;
gt;gt;
gt;gt;