If you have problems importing data into Microsoft Excel, particularly numeric, date, and time values, this is probably because of a bug in Excel, where the column type of the source data is used to determine the data type when that data is inserted into a cell within the worksheet. The result is that Excel incorrectly identifies the content and this affects both the display format and the data when it is used within calculations.
To address this issue, use the
CONCAT() function in your
queries. The use of
forces Excel to treat the value as a string, which Excel
will then parse and usually correctly identify the embedded
However, even with this option, some data may be incorrectly
formatted, even though the source data remains unchanged.
Format Cells option within Excel
to change the format of the displayed information.
Copyright © 2005, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices