Personalized dates

[MiguelCUN]

Hi everybody.

I am new, this is my first post.

We in Spanish use a form of dates like: Viernes, 5 de Enero de 2018 (is like: Friday, 5 of January of 2018).

In Excel I can use in order to obtain this format the following code: dddd, d "de" mmmm "de" aaaa

But I don't know how to use this code with .NumberFormat, the double quotation is a problem.

Sorry for my English.

 

[Dave Patton]

This is an English version of your request.
With number format custom

in the Type area, the Spanish equivalent of

dddd, d "de" mmmm "de" yyyy

Hope this helps

in VBA possibly
.NumberFormat = "dddd, d ""de"" mmmm ""de"" yyyy"

 

[MiguelCUN]

Thank you very much Dave!

Can I ask an additional question?

In my computer friday and january appears all lower case. How can I do in order that only the first letter of the day and month be uppercase (Friday and January).

 

[Dave Patton]

Your system is quite different from my system; consequently, I cannot help much more.

You could start a new thread indicating Spanish translation and VBA help.

There is an Excel function called Proper. The VBA for the function would be something like

Target.Value = Application.WorksheetFunction.Proper(Target.Value)

or possibly the Spanish equivalent of vbProperCase