Hi, i have a variable (numeric) that i need to round off (i would even be content just to shave off the extra numbers) so that it will only have two decimal places. i.e. now it is like 1234.5678690 and i want it to be 1234.56 (or if i can get it to round) 1234.57

Thanks

-- Jon Nalley (jnalley@mindspring.com), June 26, 1999

Answers

Have you tried to FORMAT() function. Try FORMAT(var, "###.00").

-- Vuong Le (vle@shl.com), July 21, 1999.