Downloading Tableau data into Excel scientific notation column

0 votes
I have a field called Acquirer Reference Number that is 23 digits long in one of my Tableau reports. Excel truncates the column and displays the data as scientific notation (as shown below) rather than the full 23-digit number when the data downloads. Although I am aware that this isn't a Tableau problem, I was curious if anyone had experienced it and if so, what the solution was.

After the data is retrieved, I've tried to reformat this column in Excel, but it turns the last few digits into 0s.

Instead of reading 2.46921690161007E+22, I prefer the complete Acquirer Reference Number to be shown as follows: 24692168345100558990040.
Sep 20 in Others by Kithuzzz
• 12,240 points
14 views

1 answer to this question.

0 votes

Due to Excel's internal floating point numbering scheme, it appears that there is a known 15-digit limitation:

https://superuser.com/questions/373997/adding-more-than-15-digits-in-excel

(Note that Tableau seems to have the same 15-digit floating point constraint for measurements and mathematical calculations.)

I recreated your scenario, and it still exports to Excel in scientific notation even when the Acquirer Reference Number is in Tableau as a Dimension and even when it is also transformed to a "String" type.

The only workaround I've found is to use the "Export Crosstab to Excel" option instead of "Exporting Data" as shown below in the "Worksheet" Menu. The outcome is comparable to adding an apostrophe before each cell in the Excel workbook. It lacks beauty and has restrictions, but it might help you achieve your goals.

enter image description here

answered Sep 21 by narikkadan
• 20,880 points

Related Questions In Others

0 votes
1 answer

Reverse back functional principle components into original data

Hi@Faheem, It depends on your Dataset. You have ...READ MORE

answered Oct 21, 2020 in Others by MD
• 95,360 points
150 views
0 votes
1 answer

How to import data from a HTML table on a website to excel?

Hello  To import any HTML file in excel there ...READ MORE

answered Feb 10 in Others by gaurav
• 18,960 points
117 views
0 votes
1 answer

How to convert data from txt files to Excel files using python

Hi , there are few steps to ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
4,889 views
0 votes
1 answer

datatable remove column on export to pdf and excel

When we are using jquery datatable for ...READ MORE

answered Feb 17 in Others by gaurav
• 18,960 points
1,391 views
0 votes
1 answer

How can I automatically add pictures in Tableau Tooltip?

Another alternative is to utilise the Viz ...READ MORE

answered Apr 5 in Tableau by Neha
• 8,920 points
143 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,720 points
402 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

answered Oct 3, 2018 in Python by Priyaj
• 58,080 points
342 views
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 58,080 points
3,287 views
0 votes
1 answer

Convert PDF into excel data

Using OpenCV, you ought to be able ...READ MORE

answered 18 hours ago in Others by narikkadan
• 20,880 points
10 views
0 votes
1 answer

Excel VBA if file closed, then open and paste, else just paste data

Slightly re-worked to add full workbook/sheet qualifiers ...READ MORE

answered Sep 21 in Others by narikkadan
• 20,880 points
14 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP