I have the following SQL table:

```
CREATE TABLE Logistics (
    country TEXT,
    Costs_Inbound CHAR(255),
    Costs_Storage CHAR(255),
    Costs_Outbound CHAR(255)
);

INSERT INTO Logistics 
(country, Costs_Inbound, Costs_Storage, Costs_Outbound)
VALUES 
("DE", "5000", "300", "600500.815523"),
("NL", "3000", "650", "250452.454"), 
("FR", "4000", "120", "750060.935775272");

```

and I use the following query to get `Costs_Outbound` from the table:

```
SELECT country,
TRIM(TRAILING '0' FROM FORMAT(sum(Costs_Outbound), 255 ,'DE_DE')) Costs_Outbound
FROM Logistics
GROUP BY country WITH ROLLUP

```

The `SQL fiddle` you can find [here](http://sqlfiddle.com/#!9/28c574/11).   

All this works fine so far.

---

However, when I export the values to Excel they are conisered as text and not as numbers.   
 Is there something I need to change in the FORMAT function so they are considered as numbers also for the Excel Export?

---

*I am not sure if the SQL fiddle that I created fully replicates the problem that I have in my original case using MySQL Workbench since SQL fiddle does not seem to have an Excel export function but I still hope you have an idea how to solve my issue.*