fraction of itself

  • Thread starter Thread starter Darljm
  • Start date Start date
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.
 
Put 10 into an empty cell somewhere and copy that cell. Select the range you
want to modify and select Paste Special -> Divide...
 
How simple! Thank you so much - I wish I had asked the question hours ago!!!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

problem with fractions to decimal 1
Formula help 1
How do I express the following calculation. 3
insert row when sum of values equals 100 3
Macro to add numbers in a text string 5
about fractions 4
How do I sort a column consisting of fractions, decimals, and who. 4
Look up multiple values 4

Back
Top