Change date format in several worksheets

  • Thread starter Thread starter Steven Shouse
  • Start date Start date
S

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?
 
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
 
Excellent! Thank you.
Steve
Gord Dibben said:
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
Click to expand...
 
Back
Top