[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

References:
[libreoffice-users] Capital letters in dates (in calc)TheJoe <asbruff@gmail.com>
Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.