| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text fraction to fraction format | Excel Worksheet Functions | |||
| How do I change fraction to fraction characters? | Excel Worksheet Functions | |||
| fraction | Excel Worksheet Functions | |||
| fraction | Excel Discussion (Misc queries) | |||
| How can I round up a fraction? | Excel Worksheet Functions | |||
Linear Mode
