Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Word destrots the comma as decimal divider in Excel
I have a really really annoying experience with Excel, 2000 as well as 2003.
Sometimes, it is not possible to write a formula like 1000*9/7,5. Excel reports error in the formula and it is the , comma that does it. It occurs not in all my Excel files, just to add to the hopeless situation. This only occurs if a Word document has been opened. Only (?=) way to solve it is to close Word and Excel. Any other had this nasty experience? |
#2
|
|||
|
|||
Maybe your windows regional setting uses a dot as the decimal point.
Does it work with =1000*9/7.5 If you want to change the character that is used for the decimal point: windows start button|control panel|regional settings applet Tvermoes wrote: I have a really really annoying experience with Excel, 2000 as well as 2003. Sometimes, it is not possible to write a formula like 1000*9/7,5. Excel reports error in the formula and it is the , comma that does it. It occurs not in all my Excel files, just to add to the hopeless situation. This only occurs if a Word document has been opened. Only (?=) way to solve it is to close Word and Excel. Any other had this nasty experience? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Dots into Commas as Decimal Divider | Excel Discussion (Misc queries) | |||
decimal place and merging to word doc. | Excel Worksheet Functions | |||
Numbers after decimal point excel to word mail merge | Excel Worksheet Functions | |||
EXCEL Decimal changes during WORD Merge | Excel Discussion (Misc queries) |