Delete decimal changes the number to ###. (Same with add decimal.) I tried changing the column width but it didn’t help. Anyone know what I need to do?
Increase the column width further… or reset the number format for that cell to General. Or at least tell us what the number is and what number format is applied.
Thanks for this. I see how it works now thanks to your info.
In case anyone else finds this confusing in the future: if you keep clicking on -decimal, the number will show properly once youve removed enough decimals to fit in the cell.