2
votes
0answers
80 views

excel 2010 not inheriting regional settings in windows 8.1

Wondering if anyone else is having this issue. In regional settings on Windows 8.1 i have display negative numbers set to display in accounting mode. eg - (1.0) instead of -1.0 Excel should be ...
4
votes
11answers
22k views

How to stop Excel Treating US dates as UK dates?

I'm in the UK, I've got a problem where I've got a list of dates supplied in US format. Excel seems to treat the ones that are valid in both formats as UK dates, (e.g. 03/01/2012 becomes 3rd of ...
3
votes
3answers
1k views

With German regional settings, how to display some cells in U.S.-currency-format e.g. $1,000.00?

My Windows 7 has regional settings set for German/Germany. This causes currency values in Excel to appear like this: 234.234,00 € However, sometimes I want currency data in a cell to appear like ...
1
vote
1answer
679 views

Make excel recognize foreign date format

I am trying to import a text file (tab-separated columns) into excel. The log file uses MM/DD/YYYY HH:MM:SS,mmmm (where mmmm is milliseconds), which excel treats as string. How can I get excel to ...