Re: String manipulations

Yes, that would get rid of the decimals... but it wouldn't get rid of
the extraneous precision. Unfortunately, the precision out to the ten
thousandth is noise... I don't need to round it either as the numbers
are artifacts of an integer to float conversion. Basically, I need to
know how many decimal places there are and then make the necessary
deletions before I can normalize by adding zeros, multiplying, etc.

Thanks for your suggestion, though.

.

Relevant Pages

  • Re: Find the first lowest value in a column that exceeds $foo
    ... You may need to round or adjust your display to get rid of any unwanted ... decimals. ...
    (microsoft.public.excel.programming)
  • Re: Get rid of Tables
    ... "Luis A. Afonso" wrote: ... > Get rid of Tables ... But when would you ever have the need to have that many decimals ... noncenral chi-sq, gamma, beta, ...) ...
    (sci.stat.math)
  • Re: Removing Decimal Places in Query
    ... >> I am using some calculated summary queries that involve ... How do I get rid of decimals in a query? ...
    (microsoft.public.access.queries)
  • Rounding Numbers
    ... I have a report, with lots of numerical fields, and I can't get rid of the ... decimals on the end of a number, I've used INT, TRUNCATE, FIX and nothing ...
    (microsoft.public.vb.crystal)