View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nicholas Nicholas is offline
external usenet poster
 
Posts: 19
Default 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?