I have a number from a field in the db that is used inside a formula. The resulting formula is text but the problem is that the number comes out with decimals which I do not want. If I was inserting the number directly onto the report I would decide the format of the number but how do I do it when I am using it from within a formula?

David

I have a number from a field in the db that is used inside a formula. The resulting formula is text but the problem is that the number comes out with decimals which I do not want. If I was inserting the number directly onto the report I would decide the format of the number but how do I do it when I am using it from within a formula?

David

Both ToText() and CStr() have optional parameters for format strings. You'll need to specify this in your formula. You'll probably want to use "#" or "#,###" depending on whether you want commas. If you use the second one, you may also want to trim off leading spaces.


Drew

or

toText( <number>, 0, "," )

The 0 represents decimal places, the "," represents the delimiter. Does this not work in 8?

Doug wrote:


That's what I get for replying too quickly. Yes, that formula works. The thousands separator is optional, so I'm assuming that you can just use and it will use the default separator defined for your computer. I haven't tested this, though, so it may just not use any separator.

Drew