column (a)

Thread view:

Thread rating:

Wayne - 29 Jan 2005 20:19 GMT

When I change the style in column (a) a date it also changes column (b) which
is hour format or style.

Signature

Wayne

Naz - 30 Jan 2005 12:05 GMT

Can you give the specific of the format uin column A then what you change it
to and the format that changes in column B.

> When I change the style in column (a) a date it also changes column (b) which
> is hour format or style.

Gord Dibben - 30 Jan 2005 18:54 GMT

Wayne

Try de-selecting "Extend list formats and formulas"

Tools>Options>Edit

Gord Dibben Excel MVP

>When I change the style in column (a) a date it also changes column (b) which
>is hour format or style.