[prev in list] [next in list] [prev in thread] [next in thread] 

List:       poi-user
Subject:    RE: Formula not working as expected
From:       Mark Beardsley <markbrdsly () tiscali ! co ! uk>
Date:       2015-11-11 7:27:09
Message-ID: 1447226829629-5720941.post () n5 ! nabble ! com
[Download RAW message or body]

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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


[prev in list] [next in list] [prev in thread] [next in thread]