fraction of itself
 

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.

fraction of itself
 

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

Jim Thomlinson


"Darljm" wrote:

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.

fraction of itself
 

How simple! Thank you so much - I wish I had asked the question hours ago!!!

"Jim Thomlinson" wrote:

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

Jim Thomlinson


"Darljm" wrote:

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.