When putting a date in the top column, it enters correctly but when i send it it shows the day of the year instead of the day of the month. how do I fix it?

asked 2019-04-19 18:29:14 +0200

jparr921 gravatar image

04/24/10 comes up as 04/114/19

edit retag flag offensive close merge delete


What do you mean by "send it". Do you mean typing "ENTER" at the keyboard? But anyway, you should check the format code of the cell and give us some information about your locale (Formatting the date 04/24/10 as 04/114/19 looks quite strange. Did you mean "04/24/19 comes up as 04/114/19"

Opaque gravatar imageOpaque ( 2019-04-19 18:40:06 +0200 )edit