Previous Topic Next Topic

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?


Related:

2 responses

Answer 1 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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
Answer 2 / 2
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

Similar discussions

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

11 responses
Unsupported signal. Please check device output
S.Agnew -
Yaya68 -

14 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses