Significant figures in a column.

[jplink49]

Hello,

I want VBA code to control the number of signficant figures in a column. In column E2:E33, values will be entered in these cells from chemical test. However, I want the values to show only 3 sig figures. (ex. 2.534 will be 2.53 or 1.986 will be 1.99. etc...) How do I do this with code?

Thanks for any help.

[protonLeah]

See the ROUND() function in VBA Help

[contextions]

What about 12.534 being rounded to 12.5? It would be less precise than 2.53 being rounded from 2.534?