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

Andy

Try recording a macro whilst doing the change manually through
FormatCellsNumberCustom.........m/d/yyyy

Assign this macro to a button placed on your Toolbar.


Gord Dibben MS Excel MVP

On Thu, 8 Mar 2007 07:27:21 -0800, Andy wrote:

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