Force format change in excel

[Benson]

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
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Benson" <Benson@discussions.microsoft.com> wrote in message
news:8CD8F4AD-D39E-492E-9760-FA94021308F7@microsoft.com...
> 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.

[Benson]

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" <Benson@discussions.microsoft.com> wrote in message
> news:8CD8F4AD-D39E-492E-9760-FA94021308F7@microsoft.com...
> > 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]

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" <Benson@discussions.microsoft.com> wrote in message
news:D380516C-820B-4B3F-B5B3-59D0EF470E43@microsoft.com...
> 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!

[Benson]

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" <Benson@discussions.microsoft.com> wrote in message
> news:D380516C-820B-4B3F-B5B3-59D0EF470E43@microsoft.com...
> > 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]

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
--