tag:blogger.com,1999:blog-4188612971984886808.post3124347607657118732..comments2023-09-15T12:02:39.708+01:00Comments on Zypher.co.uk | The Blog: Using VBA to Truncate Decimal ValuesMatthewhttp://www.blogger.com/profile/18398182170860110737noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-4188612971984886808.post-71857943468170074182011-07-05T21:24:17.141+01:002011-07-05T21:24:17.141+01:00Hi,
I was looking into the truncate problem in VB...Hi,<br /><br />I was looking into the truncate problem in VBA as well. In VBA the function to truncate decimals is called FIX().<br /><br />BTW, your function would give an "overflow error" in case dblValue is longer than the max. int value.Erik Bongershttps://www.blogger.com/profile/02409523352634066030noreply@blogger.com