Ask Your Question

format date that show a percentage instead

asked 2016-02-28 22:52:47 +0100

sdrdm3757 gravatar image

Every time I enter a date of 1/2, 1/3 or 1/4 Jan 1, Jan 2, Jan 3, or other dates that can be percentages on my spreadsheets each year it automatically changes to a tiny 1/3(rd added by me to show what I mean), 1/4(th added by me to show what I mean) that makes it look like it is a percentage. How do I get this to stop happening?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2016-02-29 00:20:58 +0100

horst gravatar image

You can deactivate the Autocorrect Option as @Lupp suggested or you enter the few dates as 1/02, 1/03 ... then the Autocorrect does not kick in. You have another one in March 3/4.

edit flag offensive delete link more

answered 2016-02-28 23:36:48 +0100

Lupp gravatar image

Isn't it a doubtable idea to write a date in exactly the same way as a fraction?
You can disambiguate dates when entering them by always giving the year explicitly.

Many users may want to exactly get what is annoying you. If you do not accept this, you will have to change your 'AutoCorrect Options...' and/or the replacement table contained therein. Details will depend on your locale.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-02-28 22:52:47 +0100

Seen: 34 times

Last updated: Feb 29 '16