How do I convert strange timestamp into date format in excel?

Question

I have this strange timestamp in an Excel spreadsheet, e.g.

2020-09-07 00:00:00.0

This is UK, so it's YYYY-MM-DD

How can I get Excel 2013 to see this as 07/09/2020 DD/MM/YYYY?

Thanks

PeterH · Accepted Answer · 2020-04-16 14:37:56Z

0

You can format Cells with different styles.

You will this formatted as a short date.

On the home tab look for the below menu drop and select the format Short Date

answered Apr 16, 2020 at 14:37

PeterH

7,48522 gold badges58 silver badges86 bronze badges

Add a comment |

1 Answer 1