MrExcel Publishing
Your One Stop for Excel Tips & Solutions

whole numbers to decimals

Posted by sean on January 23, 2002 12:13 PM

I have a column of numbers representing lengths...for example, 875, 563, 975 etc do I make this column of numbers into decimals (i.e., 0.875, 0.563, 0.975 etc etc) in one simple move, instead of typing in each one again as a decimal.



Posted by Mark W. on January 23, 2002 12:33 PM

Temporarily, enter the value, 1000, into an unused
cell. Copy it. Select the cells containing your
values to be converted and choose the
Edit | Paste Special... specifying "Values" and
the "Divide" operation. Don't forget to clear
the 1000 that your entered are the beginning of
this process.

Posted by sean on January 23, 2002 1:56 PM

wow that was simple...thanks