问题 提问于 2013年11月8日
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.
撰写回答