divide many cells by 1000
Hi,
Say your data is in cell A1
In cell B1 type =A1/1000
then copy col B and in cell A1 right clickPaste specialcheck the box for
Values onlyOk.
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade
" wrote:
I have a column with 120 entries (numbers). I want to divide all by
1000 and show the new results in the same cells. Please help.
|