Hi,
I've got a number of cells that contain dates, they don't have the ' sign in front, but are left aligned and so I think they're formatted as text.
This function seems to confirm that, saying that the Cell Data is [Text] with a [0.00] Format and contains [No Forumla].
However, when I run DateValue on these cells I get a #Value! return. Be very grateful to learn how I can solve this problem.
Sample data attached.
Bookmarks