Stop the rounding

Bruce Easton bruce at stn.com
Fri Sep 14 11:55:12 PDT 2007


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;
> 
> 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
> 
 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.



More information about the Filepro-list mailing list