Problems using Excel from different countries

[Jose Mourinho]

I recently used a US (UK?)-version of an Excel document on a laptop with a
German version of excel. There were some very strange effects when I
transferred the Excel doc back to the english Excel version.

Some cells wouldn't calculate correctly. e.g. Even simple SUM formulas
returned incorrect results or VALUE! error, but only in some cells.
Re-pasting the formula from a cell that works doesn't help - it seems to be a
bug in particular cells.

Anyone have any experience with this problem? A solution?

 

[Dave Peterson]

I only use a US version.

But if you're pasting over the values to sum, maybe the original data wasn't
really numbers--it may have contained other characters. Sometimes copying from
a web page and pasting into excel will include those non-breaking HTML
characters in the cells.

So formulas like =a1+a2 won't work.

But this would affect any version of excel (I would guess).