Problem formating cells Weine Classification Scheme for library la
 

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?

Try format cells custom ###.### I'm not certain how it will work with labels

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?

Problem formating cells Weine Classification Scheme for librar
 

thanks for that. and i'm sure that should have worked. as i'm unfamiliar
with creating those types of formulas, i used your suggestion and placed the
value of the cell (940.431) in place of "your formula", but it didn't seem to
make a difference. I set that up using the "conditional formating" and set
the condition to "formula is".

any ideas?

"bj" wrote:

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?