Joseph,
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...
But in the examples above, no matter how 'logical' they doesn't
really capture the INTENT of the programmer.
However Format works very well with integers.
"Joseph J. Strout" wrote:
> At 9:56 PM +0200 4/27/05, Eirik Karlsen wrote:
>
> >No, doesn't work.
> >The Format won't handle floating point number 'properly' because
> >of the x.xxxxxxx notation. Also there are rounding errors....
>
> Because of the what? I've never seen a number that Format won't
> format properly... can you give a simple example?
>
> Best,
> - Joe
>
> --
> ,------------------------------------------------------------------.
> | 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>
|