ExcelBanter - date format...3.1.2010

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

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

- - date format...3.1.2010 (https://www.excelbanter.com/excel-programming/440915-date-format-3-1-2010-a.html)

backmara

date format...3.1.2010

Hi all
Excamble:
In the cell: 3.1.2010, formula bar looks-- 3.1.2010 9:21:48 AM. Cell format
is general, why?

How I change this to 3.1.2010?

Bob Phillips[_4_]

date format...3.1.2010

Because it is a text string, not a date. You would need to chop the time
element off.

--

HTH

Bob

"backmara" wrote in message
...
Hi all
Excamble:
In the cell: 3.1.2010, formula bar looks-- 3.1.2010 9:21:48 AM. Cell
format
is general, why?

How I change this to 3.1.2010?

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