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