Home

R instead of dot in excel

Highlighted
Occasional Contributor

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.

5 Replies
Highlighted

Daniel, I see nothing unusual in your file, what exactly is wrong?

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?
Highlighted

Hi! This is what I mean, does it only show up on my screen? 

Highlighted

Please check File-Options-Advance if you use system decimal separator

image.png

 

Highlighted

Saved the day again. Thanks so much. 

Related Conversations
SUMMING
dumby58 in Excel on
1 Replies
how to set 2E02 into escel
Daryl20 in Excel on
5 Replies
Trouble with formulas MIN/MAX within IF statements
BDB1973 in Excel on
6 Replies
Openen en opslaan WORD en EXCEL
Turke100 in Excel on
0 Replies
historical stock data
onassis78 in Excel on
0 Replies
Excel cell formatting
snojoe10 in Excel on
2 Replies