View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bapeltzer bapeltzer is offline
external usenet poster
 
Posts: 43
Default Multiple cell unit conversion. Please help.

Enter your conversion factor, 2.54, in some random cell. Select that cell
and ctrl+c to copy. Highlight all the cells you want converted. Right-click
and select Paste Special, select divide and click OK.

"Nicholas" wrote:

I need to convert numbers in 500 separate cells in one sheet from centimeters
to inches. I can do one-by-one using the convert function and inputing the
cell location in the number field, "cm" in the "from_unit" field, and "in" in
the "to_unit" field. However I need to do north of 500 of these. How do you
do that using Microsoft Office Excel 2007?