Number format

[RustyRick]

Sometimes it doesn't seem to matter how I set properties the cell will not respond. This should have "0" decimal places and I have tried every which :banghead:way but loose

85.8823529411765 Km/Hr/Avg

What might I be missing.

 

[RustyRick]

I've had trouble with this before. And for some reason it would all of a sudden work. I've another form with the same calc. with no problem and all the properties are set the same?

 

[CJ_London]

I seem to recall having seen this in another post

85.8823529411765 Km/Hr/Avg

You are trying to format a text field rather than a number field. The way to solve it is when you contatenate the number and text you need to use the round function. e.g.

=Round(YourNum,0) & " Km/Hr/Avg"

 

[RustyRick]

I truly think it a bug. I deleted the object and put in a new one and it worked. Thanks

 

[RustyRick]

I deleted that control and put in a new one and it works fine. I should have tried that first.