Thread: HSSF cell date formatting in java

Hi there,
I have created an Excel sheet using HSSF POI.one column called "Customer delivery date" is there in the excel sheet where only date should be entered.If i enter date in this column as 12/13/11 then system should throw an error as we are excepting the date should be in dd/mm/yyyy. This is not happening because the date entered(12/13/11 ) in sheet is being validated by System date [System date format is mm/dd/yy]and while uploading the sheet ,the value to the java code is being passed as 13-Dec-2011 which is not expected.

Could you suggest the solution how to get the exact value entered in the sheet?

It would be a great help for me if you give any suggestions regarding this issue.

Thanks in advance

Rajesh