Form Control Calendar date will not change its format

[Johfra]

Hi. I have created a sheet where there are multiple users and I have added a calendar (not pop-up....still haven't figured out why it won't work for me). The calendar works fine and the linked cell too.

The thing is....the linked cell format will not change to the way I want it to...it remains as "dd/mm/yyyy". I've tried to format to the date I want using the typical date format but it always stays as "dd/mm/yyyy".

I want it to be dd-mmm-yyyy (18-Jan-2014.

Is there a VBA code that would help fix this?

Thanks.

 

[Stoneboysteve]

Johfra,

What version are you using? I was able to create a custom format with dd-mmm-yyyy by using the number format and customizing the d-mmm-yy type.

Stoneboy