Forum Discussion

Deleted's avatar
Deleted
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" format immediately. 

But now in 2016 excel,  in this process, the list won't jump to  "general" format by pushing "g" until I click the list by mouse.  This is a small issue but quite affect my working process. Since normally I can do a series of actions without mouse.

 

Please fix this

Thanks,

West

excel
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    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.

     

     

    • Deleted's avatar
      Deleted
      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's avatar
        SergeiBaklan
        MVP
        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?

Resources