Getting numbers to roundgreenspun.com : LUSENET : MW Software's Visual BASIC Descusion System : One Thread
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
-- Jon Nalley (firstname.lastname@example.org), June 26, 1999
Have you tried to FORMAT() function. Try FORMAT(var, "###.00").
-- Vuong Le (email@example.com), July 21, 1999.