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.

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
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Benson" wrote in message
...
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.

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" wrote:

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
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Benson" wrote in message
...
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.

well ... (scratching head a little here <g)
.... as long as you managed to get it to work
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Benson" wrote in message
...
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!

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" wrote:

well ... (scratching head a little here <g)
.... as long as you managed to get it to work
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Benson" wrote in message
...
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!

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
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--