Having the same date Format set for all cell with date even if typed differently

[Leicester City Fox]

Hi there

Good morning

I have a spreadsheet which has a few date columns and I wantto make use that however enter the date that it always shows in the same formatno matter how they type in the date.
For example, you type 3^rd March 2019 it shows as03/03/2019.
Does any body have any ides to makes sure all my date isshown and set in the same format for all columns?
Many Thanks
Leicester Fox

 

[gracecyl]

Hello!

you can create additional columns and then create a formula:
=TEXT(your_cell_with_date_here,"DD/MM/YYYY").

Hope this helps!