tim wrote on Thu, 4 Oct 2007 09:43:01 -0700:

tm In cell E1 I put this formula =ROUNDUP(A1*0.039,1)
tm I then copied that formula to cells F1 and G1
tm I then put some dimensions as you describe in cell A1 (I
tm used 5000 x 5000 x 100)
tm I put the cursor in A1 and did 'Data'...'Text to Columns'
tm ... 'Delimited'.... check off 'other' and put an x in the
tm box. When you 'Finish' it will show the dimensions rounded
tm up in Cells E1, F1, G1

tm "Niniel" wrote:

?? Also, how can I round up to the next whole number (no
?? decimals)? Setting the cell format may round down, so that
?? won't work for me in this case.

You might want to see if you can look at John Walkenbach's book,
"Excel 2002 Formulas" or later versions. He mentions a VBA
Extractelement function. I haven't used it but it looks like a
first step for you. The extraction might be combined with
formatting.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not