Stop the rounding

Wally Turnbull wally at tbull.com
Fri Sep 14 11:42:58 PDT 2007


A=INT(25) will give you the whole number without adding in the rounded
fraction.

Syntax:
       Then:  a=INT(n)

To get the decimal fraction
Syntax:
      Then: in = FRAC(no)

Peace,
Wally Turnbull

________________________________________
From: filepro-list-bounces+wally=tbull.com at lists.celestial.com
[mailto:filepro-list-bounces+wally=tbull.com at lists.celestial.com] On Behalf
Of scooter6 at gmail.com
Sent: Friday, September 14, 2007 2:10 PM
To: Steven Waters
Cc: Filepro List
Subject: Re: Stop the rounding

  Wouldn't just a simple  mid  statement do the trick?
 
   cb=mid(cb,1,3)
 
   Scott


 
On 9/13/07, Steven Waters <swaters at triumphinstruments.com> wrote: 
Good Day,
I have a Filepro question.

I am trying to strip the decimal out of a number.
I have this written; 

cb(10,.0)=25

25 is (10,.2)

if the number for field 25 is 880.88
I get 881 out for dummy cb
or if the number is 710.00 I get 710 instead of 71000

How do you strip out a numbers decimal and stop the rounding and dropping of

the 00

Thanks in advance,
Steve

_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
http://mailman.celestial.com/mailman/listinfo/filepro-list




More information about the Filepro-list mailing list