Recent content by mtone

Thanks for the reply. I'm using Excel 2007 SP3 (32-bit). Other things I can think of: - I also see the decimals if opening the file in google docs. - My Windows regional settings is English (Canada) - NLS session language is American - Tried changing Windows Format to Oracle Format in NLS...

Hi, I think I am also getting the same problem with all integer fields I encounter. At its simplest expression: select 2016 as y, cast(2016 as integer) as y2 from dual This query shows "2016" in the SQL window results, but 2016.00 (cell format: Number with 2 decimals) for both fields...