Multiple cell unit conversion. Please help.
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?
|