View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Suleman Peerzade[_2_] Suleman Peerzade[_2_] is offline
external usenet poster
 
Posts: 189
Default 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.