leading single quote in a date cell

Topics: User Forum
Nov 16, 2013 at 3:43 PM
I am trying to read a date cell that contains a leading single quote. Excel treats this as expected and displays the text along with the warning that "The number is formatted as text or preceded by an apostrophe. PHPExcel thinks this is a date field and returnFormattedValue provides incorrect text. readValue returns the correct text without the leading single quote. How can I test for the leading single quote and use the correct method to read the date cell?