Forum Discussion
Dannni_Yea1240
Feb 25, 2019Copper Contributor
R instead of dot in excel
Hi! I'm not sure what have happened here but I have stumbled upon the problem of having "r" in my cells? Not sure where it came from.
JKPieterse
Feb 25, 2019Silver Contributor
I don't see any "r" in your cells? I do see that you have many NaN's in cells, which cause the #Value! errors in cells that try to do calculations with those cells with NaN. I'm guessing this is Java output?
Dannni_Yea1240
Feb 25, 2019Copper Contributor
Hi! This is what I mean, does it only show up on my screen?

- SergeiBaklanFeb 25, 2019Diamond Contributor
Please check File-Options-Advance if you use system decimal separator
- Dannni_Yea1240Feb 25, 2019Copper Contributor
Saved the day again. Thanks so much.