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?