Change date format in several worksheets

[Steven Shouse]

I have about 50 worksheets in a workbook and would like to change the date
format in all. Is there a way to change all at once or must it be done
worksheet by worksheet?

 

[Gord Dibben]

Select first worksheet.

Right-click on the tab and "select all sheets" to group them.

Select data range in activesheet. CRTL + A(twice in XL 2003) will select all
cells.

Make your Format changes.

What is done to one sheet will be done to all.

DO NOT FORGET! to right-click on any tab and "ungroup" before making any other
changes unless you want to change all sheets.

Gord Dibben Excel MVP

 

[Steven Shouse]

Excellent! Thank you.
Steve

Select first worksheet.

Right-click on the tab and "select all sheets" to group them.

Select data range in activesheet. CRTL + A(twice in XL 2003) will select
all
cells.

Make your Format changes.

What is done to one sheet will be done to all.

DO NOT FORGET! to right-click on any tab and "ungroup" before making any
other
changes unless you want to change all sheets.

Gord Dibben Excel MVP