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”?
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”?
Under Tools → Options → Language Settings → Languages, add ;M-D
to the Date acceptance patterns.
Simple when you know where it is. :o)
Many thanks from this newbie.