r/googlesheets•
Nuclei

Why is sheets adding a random decimal to the end of my %?

Unsolved

A copy of my sheet with edit perms: https://docs.google.com/spreadsheets/d/1ElEleu0T06pA5kLQ-MQu5h-aVQdFtwkmPVIHkxErwJs/edit?usp=sharing

Under the "Balahara" sheet cell D75 is showing the value as "14.%", which normally I wouldn't care but when displaying that value on the main sheet (Hunting Journal) in cell K9 it's displaying the extra decimal (probably due to the concat I'm using to have a standard format cell show a %).

Where is this decimal coming from? Is there a way I can fix this easily or will I have to just live with this lol.

Thanks for any assistance!

Posted Mar 12, 2025, 7:59 PM UTC

29
Loading comments…