Date formating problem

[Kiknadze Lado]

Dear All,

I have date formating problem in Excel.
I'm exporting data from QuickBooks application to Excel and after this I
want to reformat Date column in Excel sheet.
When I select cells with date I see that it has format Text which I can't
change. When I choose another format then cell view stays same.
I found following way: 1. Select all cells with Date. 2. Edit-Clear-Format.
3. Doing operation F2-Enter for each cell.
I'm wondering how I can do same things more quickly without F2-Enter
operation for each cell.

Best wishes,
Lado

 

[Kiknadze Lado]

It's great. Thank you Tom.

Best wishes,
Lado

select column
Edit-Clear-Format
do Data=>Text to columns and select fixed width. Put the line on the right
of the data so it will not be split.

OK through the dialog.

This will do the equivalent of F2'ing each cell.

 

[Tom Ogilvy]

select column
Edit-Clear-Format
do Data=>Text to columns and select fixed width. Put the line on the right
of the data so it will not be split.

OK through the dialog.

This will do the equivalent of F2'ing each cell.