Ask Your Question
0

How to output a date as text string in a specified format?

asked 2016-08-25 18:18:17 +0100

FreeMinded gravatar image

updated 2016-08-25 18:18:56 +0100

I'm trying to concatenate text with dates. I found this question which https://ask.libreoffice.org/en/questi... helps me half the way. Using the function TEXT I can covert a date to a text string. But it only seems to work with yyyy-mm-dd as format. How can I get a text string in the dd.mm.yyyy format?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2016-08-25 20:04:48 +0100

mark_t gravatar image

Function would be changed to :

=TEXT(B6,"dd.mm.yyyy")
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-08-25 18:18:17 +0100

Seen: 52 times

Last updated: Aug 25 '16