5 Replies Latest reply: Nov 19, 2013 11:47 AM by Alan Cobbald RSS

    Dates as Numbers?

      Hi, I have extracted some dates from a spreadsheet using the crosstab converter because the dates are columns. The data all comes out OK, but the dates always come through as numbers.

       

      How do I either extract the data as a date, or convert the numbers back to dates within the document?

      I have tried many date functions such as 'date' and 'date#' with & without formatting strings, all fail & return null values.

       

      Example number : 30/09/2006 is coming out as 38990 (all settings are UK)

       

      Thanks,

       

      Alan Cobbald