Morning Jason, Double check the cell type please as I have a thought that could very well be wrong but.... You said that you set it to text and then enter the numeric value 1. It is likely that Excel automatically changes the data type of that cell to numeric when you input the value. It might be better to double check the formula by entering the number 1 and then setting the cells type so that Excel 'knows' you are entering a number that should be treated as a string. It is also likely that doing this will cause Excel to flag an error on the cell as it looks on numbers stored as strings to be a possible error.
-- View this message in context: http://apache-poi.1045710.n5.nabble.com/Formula-not-working-as-expected-tp5720885p5720941.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
