Customize Toolbar

A

Andy

I want to put a button on my toolbar that changes the number format to Date
(specifically m/d/yyyy). I tried right clicking the toolbar and going to
customize but the specific command that I am looking for is not there. I am
wondering if there is a way to personalize something like this.

Thanks
 
G

Gord Dibben

Andy

Try recording a macro whilst doing the change manually through
Format>Cells>Number>Custom.........m/d/yyyy

Assign this macro to a button placed on your Toolbar.


Gord Dibben MS Excel MVP
 
Top