Read Custom format of Excel

Joined
Jan 5, 2012
Messages
1
Reaction score
0
I want to read custom date format from excel through JAVA:
Issue:

In my excel cell is of custom format MMYYYY. Which is 011900.
When i click on it It shows me 1/0/1900. I am using jxl.jar for reading excel.

When i am reading it through java it is not taking date as 0. So it is gicing me value 121899. Dont Know why??? Could you please help me. Its very critical to my project.

Thanks in adance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,755
Messages
2,569,536
Members
45,020
Latest member
GenesisGai

Latest Threads

Top