Previous Topic Next Topic

Excel date format

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


Related:

2 responses

Réponse 1 / 2
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
24 Aug 2010 à 08:31
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
Réponse 2 / 2
goodscoolxh Posts 6 Registration date Monday 23 August 2010 Status Member Last seen 28 August 2010
25 Aug 2010 à 03:33
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 .

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
Unable to change date format in Excel
rznbyz -
Tobby -

39 responses
Excel: If Date =, then enter a value
JerrySD -
BrianGreen -

4 responses