Hi Divya,

Number format settings are identical to your screenshort. Decimal,grouping symbol show as expected in your screenshot.

For the Region format i do have "same as windows", since my windows installtion itself is german, also i use a german office, meaning also a german Excel, maybe this is the importtant point.

Hi Divya, thanks for the answering again.

I think i found out whats going on.

U used the small demo app i provided on your machine, having no problems.

I sent the Excel tile to a US collegue, he got the same problems.

So, its not Excel or any Excel version, its the file.

The difference is the locale, in my thread/app where i cteate the XLSX i had a locale of "de-DE", you had maybe "en-US".

So i changed the Culture of the thread generating the excel to US and the file can be opened without problems.

Obvioulsy a "," , "." decimal sign thing, but still not quite clear why, the cell values are doubles anyway.

So i found something, but have to rework, my localized text for column headers and so on.

Thanks for the help.

Thomas

Hi Divya, thanks for the answer.

Personally i am running Excel from the Office Professional Plus 2021 package. Collegues run Excel 2019.

All have same problem.

The screenshots were supposed to be attached in my original posts, disappeared anyhow.

I try again. Its in German though (also tried to set the culture for the workbook, did not help)

The second screenshot appears, when confirming the first message with "Yes".

It displays and charts the data correctly, so i really dont know whats going on here.

Thanks

Thomas

p.s. i again tried to attach images, they are auto deleted by the system.