does anyone know if there exists a shortcut for adding/removing decimal places (formatting)?

One of the default toolbars has a couple of icons, one that has a little arrow and .0 on the top line and .00 on the bottom. The other has the positions reversed and the arrow points the other way. These let you increase or decrease the number of decimals displayed in the currently select cell(s).

__________________Carol Marler, "Just My Opinion"

Pluto is no longer a planet and I am no longer an actuary. Please take my opinions as non-actuarial.

My latest favorite quotes, updated Nov. 20, 2018.

Spoiler:

I should keep these four permanently.

Quote:

Originally Posted by rekrap

JMO is right

Quote:

Originally Posted by campbell

I agree with JMO.

Quote:

Originally Posted by Westley

And def agree w/ JMO.

Quote:

Originally Posted by MG

This. And everything else JMO wrote.

And this all purpose permanent quote:

Quote:

Originally Posted by Dr T Non-Fan

Yup, it is always someone else's fault.

MORE:
All purpose response for careers forum:

Quote:

Originally Posted by DoctorNo

Depends upon the employer and the situation.

Quote:

Originally Posted by El Actuario

Therapists should ask the right questions, not give the right answers.

Quote:

Originally Posted by Sredni Vashtar

I feel like ERM is 90% buzzwords, and that the underlying agenda is to make sure at least one of your Corporate Officers is not dumb.

If you could live with lame limited usability (unless you found the complete rules of format specifications - I haven't looked for it), you could build your own decimal increaser/decreaser with something roughly starting with

and assign those to your own toolbar icons with accelerator shortcuts.

My definition of lame might be something that's only usable 98% of the time or crashes over 0% of the time. But you might get 98% satisfaction with an expansion of something like the above, or 100% depending on how you use Excel.