How to convert dates in excel?

Question

How to convert this date format:

18/11/2011 7:00

to this:

2011.11.18. 7:00

in excel? Can it be done with a macro or is it not necessary?

barry houdini · Answer 1 · 2012-01-26 00:07:26Z

up vote 3 down vote accepted

You can use a "custom format". Select range, right-click, select "format cells" and under number select "custom" and enter this in "Type" box

yyyy.mm.dd. h:mm

answered Jan 26 at 0:07

2

yyyy.mm.dd. h:mm Don't forget the extra dot after the day. – mischab1 Jan 26 at 0:08

good spot mischab! I missed that - amended – barry houdini Jan 26 at 0:09

feedback

1 Answer