Ask Your Question

Default number of decimal places when formatting as number (Ctrl-Shift-1)?

asked 2018-11-07 12:49:20 +0100

perlancar gravatar image

When I format cell using Ctrl-Shift-1 or the [0.0] button (Format as Number), the default number of decimal places is 2. How do I change this to, say, 0? So I don't have to click the Delete Decimal Place button everytime.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-11-07 12:59:14 +0100

gabix gravatar image

I would create a cell style with the desired settings and assign a shortcut as necessary.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-11-07 12:49:20 +0100

Seen: 104 times

Last updated: Nov 07 '18