centimetres to inches

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

aladdin - 02 Sep 2005 16:13 GMT

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

Reply to this Message

itty - 02 Sep 2005 17:35 GMT

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

Signature

itty

Reply to this Message

Gord Dibben - 03 Sep 2005 17:47 GMT

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

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

Reply to this Message