Round function is adding negative sign when exported into Excel

[cancer2006]

I am using CRW 8.5 and MS Access97. Using Round(x) function in formula to remove decimals in the numbers. The field size in MS Acess is Double and decimal places is set to Auto. Round (x) in CRW rounds the number but it is not removing the decimals.

for example. When you preview hte results in CRW8.5, the values before using Round (x) are 1,904.5, 0.00, 1,959.50 and after using Round (x)the values are 1,905.00, 0.00, 1,960.00.

When I export the file in Excel 8.0 using extended format, there is a negative(-) added to 0.00.

I would just like to see the results as 1905, 0, 1960.
Can you please point me in the right direction.
Thank you very much.

 

[IanWaterman]

THis is probably just a formatting issue in the display. right click object - format and select number format 1,234.

The negative is probably coming from rounding a number like -0.004. If all your numbers are definitely postive try
abs(round(x)).

Ian

 

[cancer2006]

Thank you very much Ian, I made your recommended changes in the format. It works beautifully. Thank you again.