I have an excell sheet with only one cell. Value in the cell is 576 Now right click it, format cells and chose custom. Here I applied this formula: _(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_) Now I use POI library to read this cell. DataFormatter formatter = new DataFormatter(); content = formatter.formatCellValue(hssfCell); where hssfCell is Cell object But it is getting read as : * 576 Even if I use formulaevaluator I get the same response So an extra * is coming in the read value
If this is still an issue for you, can you attach a sample Excel file to allow others to reproduce the problem more easily?