Multiple cell unit conversion. Please help.

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?

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?

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, copypaste specialvalues the helper column, and
delete the original.

Regards.
Fred.

"Nicholas" wrote in message
...
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?