Date formatting without my telling it to - can't undo.

[Guest]

Help.

I highlighted an entire line by clicking the line number on the left. I then clicked the "center" shortcut button.

My first column is text. The next eight are dates which I entered as "July 17," etc.

When I clicked "center," all columns were centered, which is what I wanted. HOWEVER, excel also changed the format of the dates to "17-July." [gerrrrrr]

The "undo" button is grayed out. Why?? How can I undo the date re-format??

 

[Otto Moehrbach]

MPF
Select all the cells you want to reformat. Do Format - Cells - Number
tab - Date. Select the format you want. There is one that says "Mar-01" or
something like that. That should do what you want. HTH Otto

Help.

I highlighted an entire line by clicking the line number on the left. I

then clicked the "center" shortcut button.

My first column is text. The next eight are dates which I entered as "July 17," etc.

When I clicked "center," all columns were centered, which is what I

wanted. HOWEVER, excel also changed the format of the dates to "17-July."
[gerrrrrr]

The "undo" button is grayed out. Why?? How can I undo the date

re-format??