Too Many Numbers After The Decimal

I'm trying to update the prices of several thousand products, so i'm useing the vlookup function, but the prices that are getting displayed have 5 or 6 numbers after the decimal. how can i condense this down into only 2 without using the format option.

You can try this code

Sub round_2_decimal()
'assuming the data is column a
rowcount = Cells(Cells.Rows.Count, "a").End(xlUp).Row
For i = 1 To rowcount
Range("a" & i).Select
valu = ActiveCell.Value
valu = Round(valu, 2)
ActiveCell = valu
Next
End Sub

i'm sure that works, but i have no idea where to put that. Isn't there just a find and replace to get rid of those extra numbers?

nevermind i got it and it didn't work, so i had to correct your spellings of valu with value and now it works.

Use the round () function like in

=round(vlookup(...);2)

to round the result into 2 decimal places

Hans


RChicken schrieb:

> I'm trying to update the prices of several thousand products, so i'm
> useing the vlookup function, but the prices that are getting displayed
> have 5 or 6 numbers after the decimal. how can i condense this down
> into only 2 without using the format option.
>
>
> --
> RChicken
> ------------------------------------------------------------------------
> RChicken's Profile: http://www.excelforum.com/member.php...o&userid=33601
> View this thread: http://www.excelforum.com/showthread...hreadid=558478