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