Hi Vipra

Do this: Before you multiply your numbers with 1 select only non blank
cells... How??

As usual write 1 in any cell and copy it.
Select your cells (all of them - 3000 rows). Now go to
Edit Go To..Special... Select the "Constants" option and click OK.
Now you see only non blank cells are selected.
Now do a paste special. Edit Paste Special and choose multiply. (u
already know this)
Job done in under 10 seconds.....

Thanks
Karthik Bhat
Karthikbhat<atrediffmail<dotcom
Bangalore