Converting entire columns from mm to In is this possible?

[Woundup]

I would like to convert MM to Inches, I have over 2000 metric numbers in a column and would like to highlight the column and just convert to inches and Poof all the metric numbers are now in Inches. Is this at all possible?

 

[Domski]

Hi there,

This formula should do what you're after:

=CONVERT(A1,"mm","in")

Hope it helps.

 

[erik.van.geit]

Hi, Woundup,
WELCOME here !!!!

put the value to multiply in a cell
copy that cell (Ctrl + C)
select your range
rightclick
choose "pastespecial"
choose "values" AND at the bottom check operation "MULTIPLY"
click OK

done!

kind regards,
Erik