My Oracle Support Banner

Exporting Output with Number Data To Excel Displays Numbers as Exponential/Scientific Notation (Doc ID 2520831.1)

Last updated on MARCH 13, 2021

Applies to:

Oracle SQL Developer - Version 18.4 and later
Information in this document applies to any platform.

Goal

Exporting table-column values with DataType as NUMBER into an Excel format displays the numbers as Exponential/Scientific Notation. This occurs when the column datatype has more than 11 NUMBER characters.

This is expected behavior of the MS Excel; by default the Row/Cell of Excel accepts 11 characters as standard format(General) for the cell size. Number of values more than 11 characters will be considered as exponential scientific notation in Excel.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.