5 Replies Latest reply on Mar 27, 2013 11:57 PM by Ashley Howard

    Formatting while exporting to excel


      How to format the data to be an string rather an integer while exporting to an excel or as crosstab from tableau server?


      i.e i have an column like A_Tag which has alphanumeric data stored as varchar  on the DB and pushed to tableau and displayed on the report.

      But when i view the data on the excel , which is generated using the export to excel or crosstab on tableau server. If there are numeric data like

      0251 as one row and 251 as another row,the data shown on the excel is 251 in both the rows and the prefix 0 is missed and shows as duplicates records on the excel whereas in reality it is not.