Excel date format

Closed
Nune - Aug 23, 2010 at 01:56 AM
goodscoolxh
Posts
6
Registration date
Monday August 23, 2010
Status
Member
Last seen
August 28, 2010
- Aug 25, 2010 at 03:33 AM
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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Aug 24, 2010 at 08:31 AM
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
0
goodscoolxh
Posts
6
Registration date
Monday August 23, 2010
Status
Member
Last seen
August 28, 2010

Aug 25, 2010 at 03:33 AM
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 .
0