Forum Discussion
Formulas with apostrophe
Hi, I am doing an excel training course and literally copying the formula word for word. Any formula that involves apostrophe comes back as an error. Why is this when it matches what is in my ex...
You are supposed to use double quotes " instead of two single quotes ' (apostrophes) next to each other.
=DATEVALUE("12-3-1987")
HansVogelaar Ah ha!!!! thank you! What a simple mistake but that answered has fixed so many formula issues i was having! thank you so much.
