Issue with dates

Occasional Visitor



I have recently gathered a lot of data for my master's dissertation.

Now all my dates in the excel sheet are formed this way:


As you can see this is for the 25th of February at 12:31h.

Is there a possibility to format this so that it looks like a normal date? This will be easier to use for forming graphs.


Thx in advance!

1 Reply


Format a date the way you want

If you don’t like the default date format, you can choose another date format in Excel, such as "February 2, 2012" or "2/2/12". You can also create your own custom format in Excel desktop.


Hope I could help you with these link.



I know I don't know anything (Socrates)