Change date format throughout workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can I change the date format throughout an entire workbook, perhaps via find
and replace?
 
yo can select the desired cells and change it from the cell properties by
right clicking or by using shortcut key Ctrl+1.

You can use Custom option and set your date format.

Regards,
Pranav Vaidya
 
Hi,

Two procedure are listed below namely, Select All Worksheet Replace the
Formulas for all Occurances

Procedure 1:

Do the following:

A. Select All Worksheet

1. Press the Ctrl key and select all the Sheets in the Workbook and
2. On the Tools menu, click Options.
The Options dialog box is displayed.
3. Click the View Tab.
4. Under Windows Options, click and select the Formulas check box. This will
expand all the formulas used in within the Workbook.
5. Click OK to return to the Worksheet.

Procedure 2:

B. Replace the Formulas for all Occurances.

To replace the data format for all the sheet with in the Workbook, do the
following:

1. On the Edit menu, click Replace.
The " Find and Replace" dialog box is displays with the Replace tab selected.
2. In the Find What text box enter the date format.
3. In the "Replace With" text box, enter the new date format.
4. In the Within list, select Workbook.
5. In the Search list, select Rows.
6. In the Lookin list , click Formulas.
7. Click the Relace ALL button to replace all occurances of the date format.
8. Press the Ctrl key and select all the Sheets in the Workbook.
9. On the Tools menu, click Options.
The Options dialog box is displayed.
10. Click the View Tab.
11. Under Windows Options, click and select the Formulas check box. This
will expand all the formulas used in within the Workbook.
12. Click OK to return to the Worksheet. Now the formulas are replace by
Values in each each where the formuala existed.

Challa Prabhu
 
Back
Top