Hi, I have a list of dates (approx 500 rows) on an excel spreadsheet that I
want to convert to values, how can I do this through VBA?
Date format (if it makes a difference) is for example Wed-Oct-08 and what I
want is the cell next to it to show as Wed in text (not a number, then
formatted)
Many thanks for help