Dealing with Error Type cells

[Madhav Sadhu <Ma...@saama.com>]

Hello All,
 
I have a call whose cell type is error(came to know by exporting the xls into xml and checking that column type), how ever the value inside that cell is a string value. Since the type is set to error, POI is reading this cell as error type cell. Is there any way to read a value that is contained in error type cells ?
 
Or, is there any easy way to set the cell type to string from error ? 
 
Thanks
Madhav