Change measurements for columns etc

's Computer Specifications

Hi Can I change the measurements to cm or inch when I format columns. Thanks,
Mon

's Computer Specifications

Excel 2002

"MonB" wrote:

> Hi Can I change the measurements to cm or inch when I format columns. Thanks,
> Mon

's Computer Specifications

No, you cannot not
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"MonB" <(E-Mail Removed)> wrote in message
news:500EDD94-AFA5-4B39-90DE-(E-Mail Removed)...
> Hi Can I change the measurements to cm or inch when I format columns.
> Thanks,
> Mon

's Computer Specifications

Columns("A").Columnwidth = 13 will set column width to 1 inch
Columns("A").Columnwidth = 13/2.54 will set column width to 1 cm

HTH
--
AP

"MonB" <(E-Mail Removed)> a écrit dans le message de news:
500EDD94-AFA5-4B39-90DE-(E-Mail Removed)...
> Hi Can I change the measurements to cm or inch when I format columns.
> Thanks,
> Mon

's Computer Specifications

Thank you, but where/how do I enter this? Sorry, very basic excel user.

"Ardus Petus" wrote:

> Columns("A").Columnwidth = 13 will set column width to 1 inch
> Columns("A").Columnwidth = 13/2.54 will set column width to 1 cm
>
> HTH
> --
> AP
>
> "MonB" <(E-Mail Removed)> a Ã©crit dans le message de news:
> 500EDD94-AFA5-4B39-90DE-(E-Mail Removed)...
> > Hi Can I change the measurements to cm or inch when I format columns.
> > Thanks,
> > Mon
>
>
>

's Computer Specifications

Menu Format>Column>Width
Menu Format>Row>Height

HTH
--
AP

"MonB" <(E-Mail Removed)> a écrit dans le message de news:
0BD1E213-8122-48A2-B013-(E-Mail Removed)...
> Thank you, but where/how do I enter this? Sorry, very basic excel user.
>
> "Ardus Petus" wrote:
>
>> Columns("A").Columnwidth = 13 will set column width to 1 inch
>> Columns("A").Columnwidth = 13/2.54 will set column width to 1 cm
>>
>> HTH
>> --
>> AP
>>
>> "MonB" <(E-Mail Removed)> a écrit dans le message de news:
>> 500EDD94-AFA5-4B39-90DE-(E-Mail Removed)...
>> > Hi Can I change the measurements to cm or inch when I format columns.
>> > Thanks,
>> > Mon
>>
>>
>>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I change to Metric measurements	Lorraine W	Windows XP Customization	7	22nd Jan 2010 08:31 AM
function to change metric measurements	devo	Microsoft Excel Worksheet Functions	5	7th Jul 2006 11:05 AM
How do I change the measurements from metric to imperial?	=?Utf-8?B?RnJ1c3RyYXRlZCB3aXRoIE1ldHJpYw==?=	Microsoft Access	1	10th Oct 2005 01:17 PM
Re: How to change measurements from cm. to inches?	Gord Dibben	Microsoft Excel Setup	0	3rd Sep 2004 01:46 AM
Change from Metric to Imperial (U.S.) measurements	Ross Vaughan	Microsoft Word Document Management	2	19th Sep 2003 03:05 AM