4 Replies Latest reply on Jul 27, 2016 4:27 AM by Rohan Malusare

    Year in number format in Excel cant effectively be used in Tableau

    Winson Lui

      My excel file has a column called "Year" while the data is what the name of the header shows.

      The format of the numbers under Year is number in Excel, though obviously it indicates year or time.

      When the dataset is linked to Tableau, Tableau regards this column as number in measures and I could not use it like the actual year dimensions.

      Once I change its format, all the numbers became 1905.

      Do you have any suggestion how I can better work with this column?

      Thanks.