Calc behaving badly with dates

calc
date

asked 2017-03-06 15:46:54 +0100

libreman
3 ●2

updated 2017-03-06 15:48:59 +0100

When I type 3/3 followed by enter, it converts it to date - all good :) But a few columns down the road, this behavior changes when typing different dates (J2 in this example), why? please find screenshot here: https://ibb.co/cvahBF Thanks

edit retag flag offensive close merge delete

add a comment

1 Answer

Sort by » oldest newest most voted

answered 2017-03-06 16:03:06 +0100

Mike Kaganski

8265 ●7 ●40 ●98 https://www.collaborao...

Supposedly, in your locale, the first part is expected to be month, not day?

edit flag offensive delete link

Comments

Thank you very very much!!! I am in Europe,but the pc is set to english USA LOL

libreman ( 2017-03-06 16:06:55 +0100 )edit

Note that you can change the work locale under Tools→Options→Language Settings→Languages Locale setting

erAck ( 2017-03-06 16:11:42 +0100 )edit

add a comment

Question Tools

1 follower

Stats

Asked: 2017-03-06 15:46:54 +0100

Seen: 16 times

Last updated: Mar 06 '17

Calc behaving badly with dates edit

1 Answer

Comments

Question Tools

Stats

Related questions

Calc behaving badly with dates