ACS Save Results to Excel

[HMiller]

Hello,
When I save a SQL query result to .xlsx file , all numeric/integer columns are formatted as string , so I have to run "Text to Columns" macro from Excel in order to change their attributes.
Trying to Save as .csv file and then opening from Excel works fine.
Is there any hidden option to configure it for .xlsx export
I'm running:
IBM i Access Client Solutions
(64-bit)
Version: 1.1.9.0
Build id: 2151
2022-04-06 15:20:07

Cheers
Giovanni

[MFisher]

Is it converting to string because of the NULLs ? What if you convert NULL to 0 before the export ?

[B.Hauser]

Are you perhaps dealing with different decimal separators (for example period in ACS/SQL ... and comma in Excel)?