Changing column type in excel

Hi,

I think it must be related to the formatting. how you represent the decimal. 

Best regards,

BUJA

This is my SQL Oracle command: 

SELECT TRIM(TO_CHAR(ROUND(c.invoiced_qty * ROUND(c.cf$_c_costs,2),2), '99990D99',
         'NLS_NUMERIC_CHARACTERS = '',.''')
       ) AS total_costs
FROM table_1 c
WHERE c.order_no = :order_no, I add there TO_CHAR because I want to display in excel decimal values with comma

Hi, 

No, you cannot make the column return a real NUMBER type in Excel if you use TO_CHAR in the SQL. TO_CHAR always converts the value to text (string), so Excel will treat it as text — even if it looks like a number.

use 
ROUND(c.invoiced_qty * ROUND(c.cf$_c_costs, 2), 2) AS total_costs
This returns a true NUMBER type.

• In Excel, the value will be a real number (you can sum it, format it, etc.).
• For the comma as decimal separator in Excel:
  • Keep your Windows / Excel regional settings with comma as decimal (common in Europe/Canada).
  • Or, in the Excel report, just format the column as Number with 2 decimal places and choose "Use system separators" or set comma as decimal.