The highlight duplicates functionality seems to work similarly to functions like COUNTIF in that it will treat anything that could be considered a number (including dates) as a number. In this case I assume it is coercing 5-9 to a date (either 5th Sept or 9th May depending on your region). That's why it doesn't happen with 15-19.
Everyone who confuses correlation and causation ends up dead.
How can I fix this? I already put a ' in front of the values so that Excel wouldn't change them to a date. Is there another way to make sure these values are not seen as dates?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks