Hi,

I consider myself to be an advanced user of Excel but I'm dumbfounded by a couple of simple questions in Excel 2010 running on Windows XP:

1 - I open Excel and in a new workbook type the value 1000000.1235 into a blank cell. Because of the default column width of 64 pixels, this displays in Excel as 1000000. If you then widen the column to 132 pixels, the number is displayed as 1000000.124

a) Why is Excel rounding the number to 3 decimals?
b) How can I change this to display 4 decimals for every new workbook? (nb: I know how to format a cell to show this, but I want the default to be 4).


2 - Double-click on a CSV file in Explorer that contains the below row:
A,B,C,D," 227,505,877.32 "

On my machine, Excel opens and column 5 displays as ######## until I double click the column width and then I see 227,505,877.32
On a colleagues machine in another country when they open the same file using the same version of Excel and same O/S, they see ######## until they double click & then they see 227,505,877.3

a) Why is this different for the same file on different machines?
b) How to I change colleagues machine to act the same as mine?

Many thanks!!!

Stu