G Guest Jan 29, 2005 #1 When I change the style in column (a) a date it also changes column (b) which is hour format or style.
When I change the style in column (a) a date it also changes column (b) which is hour format or style.
G Guest Jan 30, 2005 #2 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.
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.
G Gord Dibben Jan 30, 2005 #3 Wayne Try de-selecting "Extend list formats and formulas" Tools>Options>Edit Gord Dibben Excel MVP