Ask Your Question

How to get month names starting with a capital in Format->Cell [closed]

asked 2014-02-25 17:20:10 +0100

Georges Dupéron gravatar image

updated 2014-02-25 17:20:48 +0100

In French, month names don't start with a capital UNLESS they are the first word in the sencence.

For example:

Nous sommes le lundi 15 janvier 2014.

Janvier est le premier mois de l'année.

In Calc, when I click Format -> Cell -> Number, and select MMMM as th format for a date, the output is janvier, without a capital letter. Since that is the only word in the cell, it makes sense to have it start with a capital letter.

What should I do in Format -> Cell -> Number to get Janvier instead of janvier?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 15:05:51.209068

1 Answer

Sort by » oldest newest most voted

answered 2014-02-25 19:32:44 +0100

Regina gravatar image

I see no way to do it with number formatting. Do you need it as number? If it is a text, you can use the function PROPER to capitalize the string. For example, if A1 contains the date, then =PROPER(TEXT(A1;"MMMM")) would result the string Janvier.

I have tried to define a sorting list too, which has capitalized month names. But that does only work for direct text entries.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-02-25 17:20:10 +0100

Seen: 5,267 times

Last updated: Feb 25 '14