Hi, I've been maintaining a spreadsheet for months now, with a master on Skydrive and a copy sync'd back to my PC. This spreadsheet contains financial transactions so has dates and currency columns.

I am in the UK, and I always use dates in the (sensible) DD/MM/CCYY format, not the slightly mad back-to-front US version of MM/DD/CCYY.
I also display negative currency values with a '-' prefix.

A couple of days ago, with no changes by me, I noticed that all the negative currencies were displayed in brackets. 
The dates looked normal (DD/MM/CCYY), but as soon as I entered a new row it was immediately reformatted to the US style. I now have dates in both formats within the same column.

My PC's regional settings have not changes; I'm using Excel 2007 and if I create a new workbook that's fine.

This is making the product unusable for me as I don't trust the data anymore, please can someone advise.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.