centimetres to inches

A

aladdin

can anyone tell me how to change from centimetres to inches when i dra
a box in excel? in Word you can simply change it under Options bu
where oh where is it in excel? PLEASE!
:eek
 
I

itty

If u are looking for a function then try
=CONVERT(number,from_unit,to_unit). From and to units in inverted
comas("). Hope u r looking for this.
Itty
 
G

Gord Dibben

aladdin

No such option in Excel. Unfortunate, but true.

Any object that is measured in inches or centimeters.....Text Box, Drawing
Object, List Box from the Forms Toolbar for instance or Comment Box size,
would be determined by the measurment system set in your Windows Regional
Settings.

If you want to use VBA to set height and width in mm....which you could
convert 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
 
Top