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, 2022 in Others by Kithuzzz
• 38,010 points
693 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, 2022 by narikkadan
• 63,720 points

Related Questions In Others

0 votes
1 answer

(Excel) Data Entry Form inputting data into table

Solution  Fill in all the fields in your ...READ MORE

answered Oct 15, 2022 in Others by narikkadan
• 63,720 points
943 views
0 votes
1 answer

How to unmerge multiple cells and transpose each value into a new column in Pandas dataframe from excel file

Try this: df = pd.read_excel("Sample_File.xlsx", header=[0,1,2,3,4,5], index_col = ...READ MORE

answered Jan 8, 2023 in Others by narikkadan
• 63,720 points
2,140 views
0 votes
1 answer

Excel VBA search based on cell values into folders and sub-folders to get the file path and data

This will create a listing of all ...READ MORE

answered Jan 19, 2023 in Others by narikkadan
• 63,720 points
1,807 views
0 votes
1 answer

How to divide data in excel into 4 columns whose sum is almost equal to 1/4 of the sum of all values/

5049 is the sum of all numbers, ...READ MORE

answered Feb 7, 2023 in Others by narikkadan
• 63,720 points
553 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, 2022 in Tableau by Neha
• 9,060 points
927 views
0 votes
1 answer

Tableau For Loop a String

In the case of [ { ...READ MORE

answered Feb 20, 2023 in Others by Kithuzzz
• 38,010 points
434 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,740 points
996 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,090 points
911 views
0 votes
1 answer

Convert PDF into excel data

To convert data from an image in ...READ MORE

answered Oct 3, 2022 in Others by narikkadan
• 63,720 points
550 views
0 votes
1 answer

Data entry into web page from excel

Reading the File in PHP Example 1 How to ...READ MORE

answered Oct 10, 2022 in Others by narikkadan
• 63,720 points
970 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