Home

R instead of dot in excel

Dannni_Yea1240
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

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?

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

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

image.png

 

Saved the day again. Thanks so much. 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies