I can’t understand how to fix date format problem actually I already lot of data but right now I need date format in DD-MM-YY format I am trying but can’t success …
already guys posted about date format …followed but not fixed…help please
Thanks
Can this help?
The order DD-MM-YY also depends on the language set in LibreOffice. Menu: Tools>Options>Language_settings>Languages and the “Date recognition pattern” set there.
Date formats can only be applied to cell contents if the type is “Number”. For a content being “Text” the respective setting under >Format Cells...>>Numbers is of no meaning.
Issues like yours are mostly caused by text content meaning dates, but not represented as numbers as it is standard in spreadsheets.
To be sure: Look if one of the horizontal alignments is checked (set) for your cell. If so click a second time on the respective icon to switch the setting off.
If the content now is showing left aligned, it’s text and cannot be formatted.
If it is shown right aligned, it’s a number, and your issue must be caused otherwise.
You may also use the formula =ISTEXT(A1) in a different cell if you want to know if cell A1 has text.
If you need additional help, edit your question and give additional information.
First of all tell how your as-if-date is looking actually. Also tell how it came to be in that cell.