Solved: round down [Archive] - VBA Express Forum

mtsf26

11-15-2011, 07:00 AM

if i have data:
231 convert to 230
253 convert to 250
447 convert to 440
how to convert it automatically??

shrivallabha

11-15-2011, 07:07 AM

Suppose your data starts from cell A2...
A2 ---> 231
A3 ---> 253
A4 ---> 447
Then in cell B2 type the following formula and copy it down:
=FLOOR(A2,10)

mtsf26

11-15-2011, 08:02 AM

Hi thanks.it work :clap: