Dates automatically changed to currency?!

[LRiver]

Hi, have a very large spreadsheet with thousands of records and dozens of tabs. We use it everyday. Was working on it yesterday and when I clicked Save, it suddenly changed the dates into currency (£). Changing format back to date doesn't work as the date (day/mth/yr) are nonsense e.g. year is saying 1905 instead of 2017!

We use Dropbox so went to look at previous versions in the hope of restoring it but they've all got the currency instead of date too now - very strange!



Hope someone can help. Thanks.

[jeffreybrown]

Without seeing the spreadsheet it's hard to diagnose. Could it be somebody put some code in the spreadsheet that you are not aware of. It's truly strange behavior to have a sheet automatically convert on it's own.

Is it possible you could post a sample of what you have?