Issue with dates

Copper Contributor

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!

1 Reply

@Jeffo95 

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.

 

NikolinoDE

I know I don't know anything (Socrates)