Is it possible to alter the row height and column width measurement units to millimetres?
F frank Aug 28, 2004 #1 Is it possible to alter the row height and column width measurement units to millimetres?
G Gord Dibben Aug 28, 2004 #2 Frank Row heights are measured in points. There are 72 points to an inch. The number that appears in the Standard column width box is the average number of digits 0-9 of the standard font that fit in a cell. No relationship between the two. If you want to use VBA to set height and width in mm.... Ole Erlandson has code for setting row and column dimensions. http://www.erlandsendata.no/english/index.php?d=envbawssetrowcol Gord Dibben Excel MVP
Frank Row heights are measured in points. There are 72 points to an inch. The number that appears in the Standard column width box is the average number of digits 0-9 of the standard font that fit in a cell. No relationship between the two. If you want to use VBA to set height and width in mm.... Ole Erlandson has code for setting row and column dimensions. http://www.erlandsendata.no/english/index.php?d=envbawssetrowcol Gord Dibben Excel MVP
J JE McGimpsey Aug 28, 2004 #3 Of course, if you're using MacXL 2004, you can set column widths and row heights directly in inches or mm.
Of course, if you're using MacXL 2004, you can set column widths and row heights directly in inches or mm.
