Force format change in excel

[Guest]

Hello,

Right, im having a rather annoying little issue with excel at the min. I
have some data that has been imported into Excel. Basically, the date format
is YYYY/MM/DD hh:mm:ss. Now i want this to be displayed the English version
i.e. DD/MM/YY hh:mm yet when i highlight the cells and change the format of
them, nothing happens!! I have to go into each cell individually and double
click them for the date format to change....is there any way i can force this
change without having to click on each cell???

Thanks in advanced.

 

[Max]

Try Data > Text to Columns ?

Select the entire col with the date data

Click Data > Text to Columns
Click Next > Next

In step3 of the wiz, under "Column data format":
Check "Date", select "YMD" from the droplist
Click Finish

Then format the col to display as desired

 

[Guest]

Nope that didnt work...however...i have figured it out lol...your not going
to believe this. When i was selecting the columb to format i was selecting
the letter at the top so it hioghlighted the whole columb...when i selected
just the data instead, it worked!

 

[Max]

well ... (scratching head a little here <g>)
.... as long as you managed to get it to work

 

[Guest]

Arghhhh maybe not. It still doesnt work! Its so annoying. All i want to be
able to do is change the format of the cells by highlighting them> format
cells > pick my date format > press ok and hey presto! But noooo it wont do
it! I change the format and still it will only change when i double click
into each individual cell.

HELP!!!

 

[Max]

You're quite sure that the earlier suggested
Data > Text to Columns steps didn't work ?

Maybe upload a small sample copy of your file via a free filehost* and then
post the link to it in response here (the link is
generated when you upload, just copy and paste it here)

*e.g.: http://www.flypicture.com/

Kindly note that no attachments
should be posted *directly* to the newsgroup