ExcelBanter - date format...

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - date format... (https://www.excelbanter.com/excel-programming/440914-date-format.html)

backmara

date format...

Hi all
Excamble:
In the cell: Mon Mar 1, 2010 9:21:48 AM looks in formula bar -- Mon Mar 1,
2010 9:21:48 AM. Cell format is general.

How I change this to 3.1.2010?

All times are GMT +1. The time now is 08:05 PM.