Two choices

1. Either put a formula into a target cell on the worksheet referencing the
cell with the source

Range("D2").Formula = "=ROUND(B2,2)"

2. Or in program use

YourNumber = Round(YourNumber, 2)

Cheers
Nigel

"tilt64 " wrote in message
...
Hi, I would like to know if any of you would know how to change the cell
contents in the following situation:
I enter 2.1342
I want excel to change it to 2.13
not just changing the formatting, but actually changing the number to
round to the hundreths place. When I go back to that cell, I don't
want to know that there was ever a number there besides 2.13, does that
make sense? I want it to edit my number for me.
Thanks ahead of time,
Wes


---
Message posted from http://www.ExcelForum.com/