View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mehmet
 
Posts: n/a
Default 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