Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Tvermoes
 
Posts: n/a
Default 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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change Dots into Commas as Decimal Divider xenia Excel Discussion (Misc queries) 2 August 8th 05 09:48 AM
decimal place and merging to word doc. elmurado Excel Worksheet Functions 3 April 22nd 05 06:28 PM
Numbers after decimal point excel to word mail merge Andy P Excel Worksheet Functions 1 March 15th 05 11:48 AM
EXCEL Decimal changes during WORD Merge svlm Excel Discussion (Misc queries) 1 January 5th 05 04:33 PM


All times are GMT +1. The time now is 02:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"