I have text cell with
01 July 2019
I convert to date format it gives
'01 July 2019
I try put
July 01 2019
It gives
'July 01 2019
How to fix.
I have text cell with 01 July 2019 I convert to date format it gives '01 July 2019
You can’t convert a data type of existing data to another data type by formatting - never. You have data type “Text” and try to convert to data type “Number” (Calc dates are integer values counting days from 1899-12-30, which is day 0) by formatting. You need to convert your existing data (see answer from @Earnest Al) somehow to a number but such (or any other) conversion of existing data never can be achieved by changing the format of a cell to another data type (If it is a single cell only: Delete content, type CTRl+M, type 2019-07-01 and format afterwards using format code DD MMMM YYYY)
The easiest way to is to select the column of dates formatted as date and to click Data > Text to columns (make sure spaces is not ticked). It should convert your date to an actual date.
When you are importing your text file, you should specify the format (DMY in this case) of that column in the Text Import dialog. It might be useful to to tick Detect special numbers too. Cheers, Al
Thanks this fixed the issue.
Please, if the answer solves the question click 
.