Apr 07 2022 04:49 AM
Hello,
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:
2022-02-25T12:31:50.738072
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!
Apr 07 2022 05:00 AM
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)