Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 9th 05, 07:07 PM
Gramps
 
Posts: n/a
Default How do I change units of measurement in Excel?

I can't seem to get Excel to display column widths in inches. I think I've
looked everywhere with no luck. I really would like to be able to work in
inches instead of metric. Thanks for the help.

  #2   Report Post  
Old January 9th 05, 08:37 PM
Gord Dibben
 
Posts: n/a
Default

Row heights. Column widths. Objects size.

There is no option in Excel for these.

Windows Regional Settings can be changed from Metric to Imperial.

Otherwise............

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.

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 you could
convert to inches.

Ole Erlandson has code for setting row and column dimensions.

http://www.erlandsendata.no/english/...vbawssetrowcol

Gord Dibben Excel MVP


On Sun, 9 Jan 2005 10:07:01 -0800, Gramps
wrote:

I can't seem to get Excel to display column widths in inches. I think I've
looked everywhere with no luck. I really would like to be able to work in
inches instead of metric. Thanks for the help.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to change the color of all series in an excel chart in one go. Mz2 Charts and Charting in Excel 1 January 20th 05 02:07 AM
How to change the color of all series in an excel chart in one go. Marielle Charts and Charting in Excel 1 January 17th 05 05:41 PM
In Excel 2000, can I change the direction of the move selection a. GTP Excel Discussion (Misc queries) 2 January 7th 05 02:20 AM
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 1 January 5th 05 09:36 AM
change the measurement units in MS Excel 2003? celia Excel Discussion (Misc queries) 2 December 3rd 04 05:56 AM


All times are GMT +1. The time now is 02:54 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017