Cell formatting not updating
If the data contains a quotation mark, double quotation marks will replace the quotation mark, and the cell contents are also enclosed in double quotation marks.
If cells display formulas instead of formula values, the formulas are saved as text.
This file format (.txt) saves only the text and values as they are displayed in cells of the active worksheet.
To preserve the formulas if you reopen the file in Excel, select the Delimited option in the Text Import Wizard, and select tab characters as the delimiters.
Note: If your workbook contains special font characters, such as a copyright symbol (©), and you will be using the converted text file on a computer with a different operating system, save the workbook in the text file format that is appropriate for that system.
I have 24854 dates I need to change, I can't take time to double click in each cell. Click NEXT once you selected your origiinal data type The next screen, you can skip by clicking NEXT again Now you'll see a screen that lets you slect the data format that you want Select the DATE button Then, from the drop down, select the new date format you want to use. However, if I double click inside one of the date cells, after I have changed the format to the custom format, the date format changes to the correct format.
But I can't go through the worksheet and double click in each cell..would take a week!