Hotmail

Excel Web App: Changed currency and dates to US defaults

Unanswered 0 answers

Archived post from November 8, 2013. Product: Hotmail – no longer developed by its maker. Details may be out of date.

Question asked on Nov 8, 2013
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.

No answers yet

Write an answer

Your email address will not be published. Please never post passwords.

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