Ask Your Question
0

Delete decimal causes ###

asked 2018-08-24 13:58:36 +0200

Andeedy gravatar image

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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2018-08-24 14:26:02 +0200

erAck gravatar image

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.

edit flag offensive delete link more

Comments

Thanks for this. I see how it works now thanks to your info.

Andeedy gravatar imageAndeedy ( 2018-08-25 15:09:26 +0200 )edit

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.

Andeedy gravatar imageAndeedy ( 2018-08-25 15:10:35 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-08-24 13:58:36 +0200

Seen: 79 times

Last updated: Aug 24 '18