Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Benson
 
Posts: n/a
Default Force format change in excel

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.
  #2   Report Post  
Max
 
Posts: n/a
Default Force format change in excel

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.



  #3   Report Post  
Benson
 
Posts: n/a
Default Force format change in excel

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.




  #4   Report Post  
Max
 
Posts: n/a
Default Force format change in excel

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!



  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Benson
 
Posts: n/a
Default Force format change in excel

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!






  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max
 
Posts: n/a
Default Force format change in excel

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Is it possible to change the default number format in Excel? Andrew Excel Discussion (Misc queries) 5 April 24th 23 09:01 PM
How change Excel default date format to something useful mjk Excel Discussion (Misc queries) 1 September 26th 05 08:15 PM
date format in excel not in line with control panel regional setti GrahamR Excel Discussion (Misc queries) 3 August 2nd 05 06:48 PM
How do I change the default number format in Excel? DJMLLC Excel Discussion (Misc queries) 1 July 13th 05 02:16 PM


All times are GMT +1. The time now is 09:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"