G Guest May 17, 2006 #1 Hi Can I change the measurements to cm or inch when I format columns. Thanks, Mon
A Ardus Petus May 17, 2006 #4 Columns("A").Columnwidth = 13 will set column width to 1 inch Columns("A").Columnwidth = 13/2.54 will set column width to 1 cm HTH
Columns("A").Columnwidth = 13 will set column width to 1 inch Columns("A").Columnwidth = 13/2.54 will set column width to 1 cm HTH