Stop the rounding
Paul McNary
pmcnary at cameron.net
Fri Sep 14 12:08:38 PDT 2007
On Friday 14 September 2007 13:55, Bruce Easton wrote:
> Steven Waters wrote Thursday, September 13, 2007 4:07 PM:
> [..]
>
> > I am trying to strip the decimal out of a number.
> > I have this written;
> >
> >
> > 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
>
> OK - I'm going to try this again - I think I still don't understand
> the problem, plus my previous two replies, I think, were posted in
> the wrong order. :)
>
> Now that I look at your question more, Steve, I'm wondering what exactly
> you're after. Are you just trying to get the decimal point out and
> leave all the other numbers there even if they don't end in "00",
> or do you really want the last two digits to be "00" and also
> remove the "." but leave the rest of the numbers alone? I guess it's
> not exactly clear from your subject vs. the things you've tried.
>
> Bruce
>
> Bruce Easton
> STN, Inc.
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
One solution I use:
Sorry missed one thing
ca(10,.2)=25 - ".50" If you don't want rounded number
cb(10,.0)=ca * "100" I didn't change 25 to ca here
25 is (10,.2)
Paul McNary
pmcnary at cameron.net
More information about the Filepro-list
mailing list