Re: [libreoffice-users] Capital letters in dates (in calc)

Greetings,
I do not know how to achieve what you are looking for directly.
However, you can use something like this, supposing you want to display
the date of January 21, 2020:
Content of call A1: =DATE(2020;1;21) - cell format is "NNNNJ MMMM
AAAA"Content of cell B1: =SUBSTITUTE(TEXT(A1;"NNNNJ MMMM
AAAA");REGEX(TEXT(A1;"NNNNJ MMMM AAAA");"[a-
z]");UPPER(REGEX(TEXT(A1;"NNNNJ MMMM AAAA");"[a-z]"));1)Content of cell
C1: =SUBSTITUTE(B1;REGEX(B1;" [a-z]");UPPER(REGEX(B1;" [a-z]"));1)
The example above uses English function names but I normally use the
French localization. In my version (6.3), this is what comes out:
Display of A1: mardi 21 janvier 2020Display of B1: Mardi 21 janvier
2020Display of C1: Mardi 21 Janvier 2020
Just make sure the second SUBSTITUTE (cell C1) has the two REGEX
looking for "space[a-z]" and not just "[a-z]". The downside of this
approach is you need to use two additional columns (you can hide them),
or make a complicated formula that merges what I have in B1 and C1.
I hope this helps.
Rémy.

Le mercredi 22 janvier 2020 à 14:23 -0700, TheJoe a écrit :
> Hi,I have a small issue that i could not solve. First of all i'm
> sorry for mybad English... i'm Italian.
> I'm using LibreOffice 6.3.3.2 with Italian localization.
> I'm trying to format a date in Calc... What i'm getting right now
> is:lunedì 2 settembre 2024
> I would like instead to have every word starting with a capitali
> letter:Lunedì 2 Settembre 2024
> Also "Format" - "Text" - "CAPITALS" doesn't work.
> The thing i don't want to do is reformat the cell to text (it must be
> adate).
> Do you think it's possible?
>
>
> --Sent from: 
> http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy