Multiple cell unit conversion. Please help.

[Nicholas]

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?

 

[bapeltzer]

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.

 

[Fred Smith]

Create a helper column.
Insert a column.
Use the formula =a1*2.54
Copy it down.

Now you have both in and cm.
You can either keep them, copy>paste special>values the helper column, and
delete the original.

Regards.
Fred.