Problem formating cells Weine Classification Scheme for library la
it is the result of how excel handles floating decimal points
try using
= round(your fromula, 3)
"rufus" wrote:
I'm in the process of setting up worksheets for a small library in which the
Weine Classification Scheme is used. For example 940.431, 940.51, etc. I'm
also using Avery as a setup to formulate my lables. My problem is that when
the process is completed my Weine looks like 940.43100000000004 and
940.50999999999999 and not 940.431 and 940.51. No problem when there's a
single digit following the decimal.
Any ideas?
|