Excel date format [Closed]

Report
-
Posts
6
Registration date
Monday August 23, 2010
Status
Member
Last seen
August 28, 2010
-
Hello,

i have got an excel sheet which is prepared by some tool having two columns with custom and the format is mm-dd-yyyy hh:mm:ss. when i am reading the file with my application the cells are treating as string instead of date and time. But when I double click the cell and try to read again, now the cell is treating as date and time. I am using excel 2003. can you please help me how to fix this?


2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Use Text-To-Column feature and convert that column to a truely date column (as per excel). Then you can format it to what ever way you want to
Posts
6
Registration date
Monday August 23, 2010
Status
Member
Last seen
August 28, 2010

some days ago , this problem happend to me , and my sister help me fix it , but i forgot how to fix it , this evening , i will ask her again , then i will give you the answer .

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!