Hi,
Here's an old relevant thread - that I still cant figure this out. Any info is appreciated.
A cell shows "09/03/2019" . It is formatted as text.
I need to be able to do a vlookup on this "09/03/2019", but 9/3/2019 does not work, even after using a custom format of mm/dd/yyyy.
The only way I've found to lookup 09/03/2019 is to type a ' and then 09/03/2019. Then type ' and the next date, etc etc etc. Dragging dates down is not available.
Any ideas on how to do a vlookup on a mm/dd/yyyy ?
Thanks very much!!!!!!!