Ask Your Question

Is there any way to stop Calc from automatically changing a single '-' to a long '-' when you enter it?

asked 2016-07-28 14:51:06 +0100

Northern_Dude gravatar image

Entering fields like "Multimedia - MP3" for catagories does this automatically and I am forced to edit and change it back which is time consuming for the spreadsheets that I'm presently working on. I can't find anything about this in the help.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2016-07-28 15:00:21 +0100

floris v gravatar image

updated 2016-07-28 19:31:20 +0100

Tools - Autocorrect options; select the Replace tab. Delete the line with hyphen and en dash ("long" dash; on my list it comes first).

edit flag offensive delete link more


Thanks for the tip but I am not sure how to put tab in a field as it moves the cursor to the next field. Still, your comment gave me an idea and I used '- to be replaced with the - and it worked fine.

Northern_Dude gravatar imageNorthern_Dude ( 2016-07-28 19:21:17 +0100 )edit

Edited reply, it was apparently a bit ambiguous. :)

floris v gravatar imagefloris v ( 2016-07-28 19:30:02 +0100 )edit

answered 2016-07-30 14:28:40 +0100

Northern_Dude gravatar image

After doing some digging, I found that the Tools -> AutoCorrect Options -> Options Tab has a "replace dashes" checkbox. Unchecking this will stop the automatic conversion to the wide '-'. Wish I had seen this sooner but hope this tip helps anyone else that prefers the shorter '-'.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-07-28 14:51:06 +0100

Seen: 224 times

Last updated: Jul 30 '16