Numbers in Text Fields Showing Scientific Notation

[fbcideas_migusr]

When I import data from an Excel spreadsheet with a column containing both numbers and text (i.e. an ID column where some IDs have letters), the numeric IDs get displayed in scientific notation. This is a major problem as people need to be able to read these IDs.

[fbcideas_migusr]

To clarify, this problem is not visible in Excel - the numbers are all displaying correctly there, it's only on import into Power BI that they turn into scientific notation, which renders them useless.

[fbcideas_migusr]

Hey Charles, these Excel sheets are automatically exported. Does this mean I'll have to go into the sheet every day and manually add quotes before all the IDs with large numbers? Couldn't there be an option to turn this on/off?

[fbcideas_migusr]

Hey Chuck, Try out these values: VT12069028 - Fine 26 - Fine 73 - Fine 680310381602 - Displayed as 6.803E+11 617627990719 - Displayed as 6.176E+11 541500120505 - Displayed as 5.415E+11

[chass]

This is by design. To have Excel NOT do this please append a quote ' before these ids.

[chass]

Hello Jonathan, I just tried this and not seeing what you are describing...using the values below. That said guessing this is not a bug and you might be able to convert values back to text. That said if you supply an example of the values you are importing i can verifying there isn't any data loss in the conversion from text to numbers ID Amount Qty 123n 12 2 n456 13 1