Thanks Eric, it looks like Format() is the way to go..
>>The round() command in VB rounds up if the value is .5 or higher, >>but what I need is to round up if there is any fraction whatsoever, >>so 1.1 would = 2, and 45.23 = 46, etc. >> >>Is there any easy command besides breaking into the MOD functions? > > >Read the FAQ I have posted on that topic at http://www.levelextreme.com/wconnect/wc.dll?FournierTransformation~2,33,Forum=21,29,800