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

[lmandel]

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

[TonyE]

Hi Larry

Have you tried using the options on the formatting toolbar?

[lmandel]

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

[HansV]

Macros with these instructions:

CommandBars("Formatting").FindControl(ID:=398).Exe cute

for increasing number of decimal places, and

CommandBars("Formatting").FindControl(ID:=399).Exe cute

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.

[JohnBF]

There's a list of shortcuts in <!post=Star Post,68646>Star Post<!/post>. You'd probably need to write a macro and bind it to a Ctrl-Shift-Alpha Key combination.

[lmandel]

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

[HansV]

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>post 71782</post#> for a macro to list all IDs.

[pieterse]

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

[MarkD]

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

[lmandel]

Jan Karel,

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

Larry