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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do i change the default value of measure from points to inches when
setting the width and hight of cells?
 
You don't. Excel uses only points for these measures
best wishes
 
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
 
You must log in or register to reply here.

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

To much space in my cell? 3
Column width in inches??? 3
Excel 2003 ~ How to change the default units of measure? 2
how do i change measurement units from inches to centimeters in ex 2
Measuring cell width and height for printed paper 6
Seperating Feet, inches and fractions 6
Margins measured (quoted) in inches in Excel 1
Set Column Width to Inches? 0

Back
Top