Shortcut/macro to increase/decrease # decimal plac (Excel XP)

Topic

New Reply

Is there a shortcut key or easy way using macros to increase/decrease the number of decimal places? I’ve searched Microsoft’s list of shortcuts and played with macros with no success.

Thanks!

Larry

Reply | Quote

Replies

Hi Larry

Have you tried using the options on the formatting toolbar?

Reply | Quote

Tony,

Thanks – that’s the method I usually use. I am teaching an Excel class and was asked this question by a student who is prefers short cut keys whenever possible, but couldn’t find/create a solution.

Larry

Reply | Quote

Macros with these instructions:

CommandBars(“Formatting”).FindControl(ID:=398).Execute

for increasing number of decimal places, and

CommandBars(“Formatting”).FindControl(ID:=399).Execute

for decreasing the number of decimal places, will probably work on a system that uses a decimal point. It will fail on systems using something else, such as a comma, as decimal separator.

You could assign keyboard shortcuts to those macros.

Reply | Quote

Hans,

As usual, you are the man!!!! Thank you very much. Is there a good reference that you can refer me to re “Find Control” with a complete list of all the codes (398, 399…) so I apply these technique to other applications?

Thanks again!

Larry

Reply | Quote

I simply used
? CommandBars(“Formatting”).Controls(“Increase Decimal”).ID
and
? CommandBars(“Formatting”).Controls(“Decrease Decimal”).ID
in the Immediate window. You could use CommandBars(“Formatting”).Controls(“Increase Decimal”) too, instead of the expression with the ID’s, but then the code would only work on an English language system.

See for example post 71782 for a macro to list all IDs.

Reply | Quote

I simply used
? CommandBars(“Formatting”).Controls(“Increase Decimal”).ID
and
? CommandBars(“Formatting”).Controls(“Decrease Decimal”).ID
in the Immediate window. You could use CommandBars(“Formatting”).Controls(“Increase Decimal”) too, instead of the expression with the ID’s, but then the code would only work on an English language system.

See for example post 71782 for a macro to list all IDs.

Reply | Quote

You can find all of them (for all Office applications) in my xlmenufundict

Reply | Quote

Jan Karel,

Thank you – the list is exactly what I am looking for!!!!

Larry

Reply | Quote

Jan Karel,

Thank you – the list is exactly what I am looking for!!!!

Larry

Reply | Quote

You can find all of them (for all Office applications) in my xlmenufundict

Reply | Quote

Hans,

As usual, you are the man!!!! Thank you very much. Is there a good reference that you can refer me to re “Find Control” with a complete list of all the codes (398, 399…) so I apply these technique to other applications?

Thanks again!

Larry

Reply | Quote

Macros with these instructions:

CommandBars(“Formatting”).FindControl(ID:=398).Execute

for increasing number of decimal places, and

CommandBars(“Formatting”).FindControl(ID:=399).Execute

for decreasing the number of decimal places, will probably work on a system that uses a decimal point. It will fail on systems using something else, such as a comma, as decimal separator.

You could assign keyboard shortcuts to those macros.

Reply | Quote

There’s a list of shortcuts in Star Post. You’d probably need to write a macro and bind it to a Ctrl-Shift-Alpha Key combination.

Reply | Quote

You can also find an updated (for Excel 2003) list of keyboard shortcuts at this MS web site:

Office Online – Excel shortcut and function keys

Note: click “Show All” link at top of page to display full list, which can be printed. I copied these into a spreadsheet, see attached file (XL 2K format). The format is somewhat different than the other list which was based on Help file. Note – some of these may only apply to XL 2003/2003 (ie, Task Pane shortcuts). Still apparently no keyboard shortcut for increasing/decreasing the decimal places. As noted on web site, “If an action you use often does not have a shortcut key, you can record a macro to create one.”

HTH

Reply | Quote

There’s a list of shortcuts in Star Post. You’d probably need to write a macro and bind it to a Ctrl-Shift-Alpha Key combination.

Reply | Quote

Tony,

Thanks – that’s the method I usually use. I am teaching an Excel class and was asked this question by a student who is prefers short cut keys whenever possible, but couldn’t find/create a solution.

Larry

Reply | Quote

Hi Larry

Have you tried using the options on the formatting toolbar?

Reply | Quote