Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Adding Swedish dictionary has changed my date format

I have been trying to add a Swedish dictionary so I can spellcheck a document in Swedish I am typing and have asked for help in another question.

After my efforts I now find an unwanted consequence. I have many calc documents where I have dates. These dates now no longer show in UK format. Generally I select DD-MMM-YY, viz. 30 Oct 18. These now show in Swedish format as 30 okt 18 (Don't ask me why the month is no longer capitalised, I don't know).

Now I could go through every single instance and change and copy, paste special, paste special, format, return, but this would take hours, if not days. Given this happened automatically through some 'inadvertent' click that I used to try to solve my other problem can I change it back again similarly?

(Oh and any tips on the 'select all squares with a bicycle would be helpful. For the last question I asked I had at least 10 of these (bicycles, cars, traffic lights, fire hydrants) before finally my question posted; I nearly gave up)

Thank you for reading this and thank you even more for any help.