Forum Discussion

Anonymous

Jul 11, 2017

Number format issue

Hi While using 2013 Excel, I used to set number format list in Quick Access Toolbar as the 5th buttom, so that I can change data number format by alt+5, and push "g" to automatically select "general...

excel

SergeiBaklan

Diamond Contributor

Jul 11, 2017

Hi West,

In 2016 is the same - you may add Number Format as 5th or whatever button, press Alt+5, and you'll be on General format by default, just press Enter. Or you may start typing format name "g"will stay on General, "a" moves you on Accounting, etc. No mouse click is required.

Anonymous

Jul 12, 2017

I report this because I can't. I think it a bug or it just happens in my Excel? :(

When I try to alt+5 select number format list and type "g" several times, it shows this window. Does it relate to my setting?

SergeiBaklan
Diamond Contributor
Jul 12, 2017
Hi West,

Looks strange. If you click by mouse on your Number Format button do you see something like this:

And do you sure nothing is assigned on Alt+5 in your environment? If you try to place this button let say on 10th position in Quick Access bar and press Alt+10 will it be the same?