I have an excel spread sheet with many columns and rows of values. But I noticed different decimal separation if I open it either in excel or in my browser (file-preview of OneDrive). I took a snapshot of the same spreadsheet lines, e.g. look at row 13. The left part is opened in standard excel program office365 and on the right the same is opened in browser.
As we can see the values in the browser, e.g. 22,826253
are correct with correct decimal punctuation, however the same value on the right 22,826,253
has a second decimal separator!! How can I change this to normal?
I already looked here, but changing the cell format to "general" didn't help: with some columns it did help, with others (e.g. time stamp) not.
What can I do please?
EDIT:
Not sure if this is helpful, but if I load the spread sheet for the first time into excel program, it shows many ######
-values in cells:
Only once I widen the cells width does this wrong formatting 22,826,253
appear.
,
is not the decimal separator but the thousands separator. so in the US22,826,253
is 22 million 826 thousand 253 not 22 with a decimal of826253
22,826253
- a decimal value. So how can I change the thousands separator22,826,253
in the one excel program to instead show decimal22,826253
?