how do i change the default value of measure from points to inche.

G

Guest

how do i change the default value of measure from points to inches when
setting the width and hight of cells?
 
G

Gord Dibben

yoyo

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....which can be converted
to inches....

Ole Erlandson has code for setting row and column dimensions.

http://www.erlandsendata.no/english/index.php?d=envbawssetrowcol

Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Row and column, value = 1 inch 1
How do I change Ruler Unit of Measure in Word 2007 2
Excel 2003 ~ How to change the default units of measure? 2
To change measurement unit in Excel 2
Change points to inches?? 12
Measuring cell width and height for printed paper 6
How do I change unit of measure in one document? 5
Ruler Unit Of Measure Settings 5

Top