Change measurements for columns etc

[MonB]

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

[MonB]

Excel 2002

"MonB" wrote:

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

[Bernard Liengme]

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

"MonB" <[email protected]> wrote in message
news:[email protected]...
> Hi Can I change the measurements to cm or inch when I format columns.
> Thanks,
> Mon

[Ardus Petus]

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" <[email protected]> a écrit dans le message de news:
[email protected]...
> Hi Can I change the measurements to cm or inch when I format columns.
> Thanks,
> Mon

[MonB]

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" <[email protected]> a écrit dans le message de news:
> [email protected]...
> > Hi Can I change the measurements to cm or inch when I format columns.
> > Thanks,
> > Mon
>
>
>

[Ardus Petus]

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

HTH
--
AP

"MonB" <[email protected]> a écrit dans le message de news:
[email protected]...
> 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" <[email protected]> a écrit dans le message de news:
>> [email protected]...
>> > Hi Can I change the measurements to cm or inch when I format columns.
>> > Thanks,
>> > Mon
>>
>>
>>