Random Rounding in Google Sheets

  • Thread starter kyphysics
  • Start date
132
46
If anyone knows what on Earth could be happening and how to fix this, please let me know.

I'm using Google Sheets. I have lots of cells where I'm manually entering numbers with some having decimal places. All of a sudden, a random cell rounds a number UP for me. WTH? There's no rounding (that I can tell) in other cells.

Anyone know why this happens and how to remove it so I only get what I enter (i.e., no rounding)?

Props to anyone who knows how to fix this!
 
33,384
9,107
Is it feasible to delete the entire row or column this cell is in? Copy the remaining cells to a new row/column before if needed and if that doesn't create too many problems elsewhere in the sheet.
 

anorlunda

Mentor
Insights Author
Gold Member
7,553
4,263
This is just a guess. The number may be fine, but the default formatting of that cell may be different. You can test that by changing the number format of the offending cell. Increase the number of decimal digits displayed.

Why the default may be different for different cells, I have no idea.
 

berkeman

Mentor
55,718
5,803
The number may be fine, but the default formatting of that cell may be different.
That was my thought as well. I'm not familiar with Google Sheets, but in Excel I sometimes run into formatting issues when adding information to a spreadsheet.

I don't know what a similar fix would be in Google Sheets, but in Excel you can copy a cell (that you know has generic formats) onto a 2-D range of cells. That's one way to clear out any leftover formats in the target cells. There may be some other Edit option that will let you clear the formats in a selected 2-D range of cells.

1568401185036.png
 

anorlunda

Mentor
Insights Author
Gold Member
7,553
4,263
An additional speculation is that the program a certain number of cells are created and populated with default empty cell values on startup. Later, more rows and columns can be added, and populated with empty cell default values.

It would be a bug if those two cases of default values were not the same, but it is certainly conceivable.
 

Want to reply to this thread?

"Random Rounding in Google Sheets" You must log in or register to reply here.

Related Threads for: Random Rounding in Google Sheets

Replies
1
Views
587
  • Posted
Replies
8
Views
2K
  • Posted
Replies
2
Views
2K
  • Posted
Replies
9
Views
2K
  • Posted
Replies
16
Views
2K
  • Posted
Replies
5
Views
2K
  • Posted
Replies
1
Views
3K
  • Posted
Replies
11
Views
2K

Physics Forums Values

We Value Quality
• Topics based on mainstream science
• Proper English grammar and spelling
We Value Civility
• Positive and compassionate attitudes
• Patience while debating
We Value Productivity
• Disciplined to remain on-topic
• Recognition of own weaknesses
• Solo and co-op problem solving
Top