Ask Your Question

Date format

asked 2018-05-05 01:26:48 +0100

SKE gravatar image

In Calc, if I enter "5/6" the format automatically converts it to "6-May-18."

How do I set Calc so it will make the same conversion when I enter "5-6"?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-05-05 04:28:38 +0100

Jim K gravatar image

Under Tools -> Options -> Language Settings -> Languages, add ;M-D to the Date acceptance patterns.

edit flag offensive delete link more


Simple when you know where it is. :o)

Many thanks from this newbie.

SKE gravatar imageSKE ( 2018-05-05 07:49:09 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-05-05 01:26:48 +0100

Seen: 41 times

Last updated: May 05 '18