5 Replies Latest reply on Feb 16, 2020 10:08 PM by Bhadresh Maniya

    Crosstab csv export from server with 'Text' values is treated as Exponential in excel

    Harikrishnan N

      Hi All,

      I have a String Column with value '7E5'. When i download the data from Tableau server as Crosstab , it is downloaded as .csv file.

      When I open it with MS. Excel it shows '7.00E+5'.

      When I change the Excel column to Text format, it becomes '700000'.

      Result expected : 7E5 in the excel too.

       

      Can you kindly help to fix.

       

      Server:

       

      MS.Excel:

       

      Thanks in advance.