Help!

Can you format cells in Excel by inches? If so how?

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Setup RSS
Next:  calculate childs age Excel  
Author Message
Adrienne
External


Since: Mar 16, 2005
Posts: 18



PostPosted: Wed Mar 09, 2005 4:35 pm    Post subject: Can you format cells in Excel by inches? If so how?
Archived from groups: microsoft>public>excel>setup (more info?)

I'm not sure if this is possible but I need to do it for work. Please Help
Back to top
Gord Dibben
External


Since: Feb 23, 2004
Posts: 9431



PostPosted: Wed Mar 09, 2005 11:25 pm    Post subject: Re: Can you format cells in Excel by inches? If so how? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Adrienne

Do you mean as in column widths, row heights, objects?

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/index.php?d=envbawssetrowcol


Gord Dibben Excel MVP

On Wed, 9 Mar 2005 10:35:03 -0800, "Adrienne"
wrote:

 >I'm not sure if this is possible but I need to do it for work. Please Help
Back to top
Dr. Hay
External


Since: Oct 18, 2009
Posts: 1



PostPosted: Sun Oct 18, 2009 8:11 pm    Post subject: Re: Can you format cells in Excel by inches? If so how? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

"Gord Dibben" wrote:

> Adrienne
>
> Do you mean as in column widths, row heights, objects?
>
> 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/index.php?d=envbawssetrowcol
>
>
> Gord Dibben Excel MVP
>
> On Wed, 9 Mar 2005 10:35:03 -0800, "Adrienne"
> wrote:
>
> >I'm not sure if this is possible but I need to do it for work. Please Help
>
>
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Setup All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum