Excel custom buttons

Hello Phil,
I hope you enjoyed your Access training session with us.

In response to your question, since you have created this format yourself, it will not be available as a selectable custom button option. However, you could record a macro that changes the value in the cell to this format, and then add the macro to a custom button.

I hope this resolves your question. If it has, please mark this question as resolved. If you require further assistance, please reply to this post. And please feel free to ask any other questions you may have.

Have a great day.

Regards,
Mara
Microsoft Office Specialist Master Trainer