Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problems using Excel from different countries
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problems using Excel from different countries
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). Jose Mourinho wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date format problems when used in different countries | Excel Discussion (Misc queries) | |||
Using Excel in different countries | Excel Worksheet Functions | |||
world countries | Excel Discussion (Misc queries) | |||
Maps of countries of the World. | Excel Worksheet Functions | |||
Difficult to open files in Excel in different countries | Excel Discussion (Misc queries) |