Excel Scientific notation Issue

??

This was a known issue, you can find more in the Internet.

Excel would treat text (can display with number) more than one numbers, it'll convert to scientific notation display.

It is not a issue now, but if your text content length was more than, the issue occurs, it would discard the value and

Set default is zero.

If your number is 1234567891012345, Excel would convert to 1234567891012340 if your display back from scientific notatio N.

Scenario, we dump table content to CSV file, when we open the CSV file with Excel, we find one column display as Scientifi C notation, this is not the what we want.

Another one is, one column we contact some value like 123,125,4566,..., Excel take this text as number just like we apply a Custom format on number, scientific notation occurs again and some values miss in Excel

Solution:

When we dump data from Oracle or SQL Server to CSV, we should add single quote.

Select "| | column from table;

Excel would take the this column as text. And not display the single quote before value. It is useful.

Even in the data filter.

??

??

Excel Scientific notation Issue