I have a spreadsheet with 600,000 records. One column is filled with dates in the format 12/02/2013. I need to convert those dates to number in the format 20131202.
These are the steps I've been using successfully on much smaller spreadsheets:
1. copy and paste my dates into a blank spreadsheet
2. convert to correct format using =TEXT(A2, "yyyymmdd")
3. copy--> paste back into my original spreadsheet as a value
4. then right click and select "convert to number"
Problem is, when I try this on a spreadsheet this large, it crashes. Any help would be greatly apprreciated!