Stange numbers

P

pgarcia

Hello all,
Some one in my office has ask me for help and I could not figure this out.
The setup:you have a set of rows with number and those number are formatted
with "Accounting" two decimals no symbol. When doing a manual sum or using
the AutoSum, whey would my number come out like so “0.00†and not a dash? If
you increase the decimal out there is a number, “0.00000000000000164316543â€.
?? The number are whole numbers, e.g. 24.25, 100.25, 562.64 ect.

Thanks
 
G

Gary''s Student

You may want to use the =ROUND() function to insure only two places are held.
This is in addition to formatting, which insures only two places are visible.
 
T

T. Valko

It's a "rounding issue" that occurs when converting binary to decimal.

Use the ROUND function:

=ROUND(SUM(A1:A10),2)
 
Top