Change date format in several worksheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steven Shouse - 30 Oct 2004 21:09 GMT

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?

Reply to this Message

Gord Dibben - 30 Oct 2004 23:17 GMT

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

>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?

Reply to this Message

Steven Shouse - 01 Nov 2004 00:58 GMT

Excellent! Thank you.
Steve

> Select first worksheet.
>
[quoted text clipped - 21 lines]
>>format in all. Is there a way to change all at once or must it be done
>>worksheet by worksheet?

Reply to this Message