I have a list of 1000+ dates such as 11/15/2009.
My vlookup doesn't work unless it's formatted in serial format.
I can go cell by cell, clicking in each and hitting ctrl + ~ to make it work, but that will take forever.
Is there a shortcut that I can just highlight all the cells and accomplish the same thing?
Bookmarks