fraction of itself

D

Darljm

Hi, I have a column of numbers copied in to a spreadsheet that I would like
to have displayed as 1/10 of the numbers currently displayed. For example,
the numbers now read 100, 80, 125, and I would like to convert them all to
10, 8, 12.5, etc. I hope I'm explaining this clearly enough! I appreciate
any help.
 
J

Jim Thomlinson

Put 10 into an empty cell somewhere and copy that cell. Select the range you
want to modify and select Paste Special -> Divide...
 
Top