View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
 
Posts: 1,397
Default 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?