Converting Numbers to Strings

[Dave]

I have a number field - [Enterprise Number1] - that I used in a
calculation and came up with -0.61. I want to append " Days" onto the
end of the -0.61. I make [Enterprise Text1] = [Enterprise Number1] and
I get -0.61 in [Enterprise Text1]. I make [Enterprise Text1] =
[Enterprise Number1] & " Days" - I get -0.608360380573517 Days. It
appears that appending the " Days" automatically converts the number
-0.61 to a string and converting a number to string expands it out a
bunch of decimal points. How do I get "-0.61 Days" in the text field -
or how do I round to 2 decimal places (or 1 decimal place for that
matter)? (I know I can just grab the left 4 characters) Thanks.

 

[Claudio Hidetoshi]

try this: format([Number1];"###,###,##0.00") & " Days"

Round only 2 decimal numbers.

Claudio Hidetoshi - Brazil.