Form Control Calendar date will not change its format


Joined
Aug 30, 2012
Messages
13
Reaction score
0
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.
 
Ad

Advertisements

Joined
Sep 3, 2008
Messages
164
Reaction score
5
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top