Posted to microsoft.public.excel.misc

nankerp

external usenet poster

Posts: 1

Does Excel calculate wrong when using many decimal after comma?

I have put 1592,10 in cells A1 to A57 and made a SUM(A1:A57) in B57.
The result is 90749,70000000010. That is wrong. I should be
90749,7000000000000.

Helge

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Decimal dot to Decimal Comma	Ananth	Excel Discussion (Misc queries)	3	January 10th 08 10:14 AM
decimal to comma	George P	Excel Discussion (Misc queries)	2	December 15th 06 09:46 PM
I get a comma instead of a decimal why ?	Donnie	Excel Discussion (Misc queries)	2	September 25th 06 09:08 PM
Batch converting CSV files from comma-decimal to period-decimal	Nodles	Excel Discussion (Misc queries)	3	July 5th 06 06:57 PM
Word destrots the comma as decimal divider in Excel	Tvermoes	Excel Discussion (Misc queries)	1	August 26th 05 03:01 PM

All times are GMT +1. The time now is 11:29 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us