Was hoping a [return] feature might have been added to number formating by now but still none. Any chance of this? I'd like to divide the date over two lines by having an inline return eg. DD/MM[return]YYYY
I create such formats sometimes manually. But I don't know how many date formats can or should be at maximum be included in LO to not overload the date format list.
This is more to do with user defined formats. Was hoping for some way to include a [return] into the format so that the result can be made to appear over two or more lines. eg. 10/11 2015 in a single cell by a user format something like: DD/MM[return]YY The user need only type 10/11/2015 but it would appear over the two lines? Presently I have to use two cells with the date in the top and a formula in the bottom which just feels messy and awkward. Any chance of adding something like this?
If you press: 10/11 Ctrl+Enter 2015 this will format your text as you wanted and also this would be the date format.
Thanks BogdanB. I can already do that. Unfortunately when you do this it looks like a date but no longer behaves like a date. So you can't use it in any simple formulations. You could use string extraction I guess but something simpler would be nice? It would also be nice if the inputer could just enter a date as normal and it automatically show in this desired format without them having to know or deal with the ctrl-enter key combination.