Yeah I knew it! :o)
I guess Format isn't the right thing to use in my case where:
the number MUST be 5 digits, and
there MAY be a dp (unknown where), and
there MAY be a minus sign.
Format can do some of these, but not all 3 at the same time (as far as I
know).
If we had the fictional "Precision =5" then instead of my 'messy' code we
could simply use
data=Left(str(y),5) ' (for positive numbers)
data=Left(str(y),6) ' (for negative numbers)
"Joseph J. Strout" wrote:
> At 10:45 PM +0200 4/27/05, Eirik Karlsen wrote:
>
> > y=99.9990000
> > data=Format(y,"#####")
> >returns "100"
> >
> > y=9.99990000
> > data=Format(y,"#####")
> >returns "10"
> >
> > y=9999.90000
> > data=Format(y,"#####")
> >returns "10000"
> >
> >
> >As one of the RB team I'm sure you'll have a good and perfectly
> >logic explanation to why this happens...
>
> Yes: Format is doing exactly what you've told it to. The whole point
> of the Format function is that you can tell it what format you want;
> if you tell it "#####" (or the equivalent, "#"), then you're telling
> it that you WANT the number displayed as the closest integer, without
> a sign.
>
> If you want a number displayed as an integer, but with a sign, use
> "-#" as your format string.
>
> If you want it displayed as a decimal, with as many digits as needed
> to the right of the decimal point, use "-#.#".
>
> If you want a fixed number of places to the right of the decimal
> point, say five of them, then you might use "-0.00000".
>
> In short, tell Format what format you want -- if you give it an
> integer format, don't be surprised that it displays things exactly as
> you asked!
>
> Best,
> - Joe
>
> P.S. See the Language Reference for more details and examples of the
> format specifiers.
> --
> ,------------------------------------------------------------------.
> | Joseph J. Strout REAL Software, Inc. |
> | joe at realsoftware dot com http://www.realsoftware.com |
> `------------------------------------------------------------------'
> _______________________________________________
> Unsubscribe or switch delivery mode:
> <http://www.realsoftware.com/support/listmanager/>
>
> Search the archives of this list here:
> <http://support.realsoftware.com/listarchives/lists.html>
--
*******************************************
VISIT MY HOME PAGE:
<http://home.online.no/~eikarlse/index.htm>
LAST UPDATED: 23/08/2003
*******************************************
Regards
Eirik Karlsen
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|