Stop excel from formatting downloaded data

When Excel automatically converts downloaded registration data into a time or date, you need to follow these steps:

 

1.       Download and save the file to your computer

2.       Open a new sheet in Excel

3.       Go to the “data” menu item and select import external data

4.       Select the file you saved

5.       Choose delimited for the radio button and click next

6.       Check comma and unselect tab on the delimiter options and click next

7.       Click on the columns that are being automatically formatted and set the format to text

8.       Click finish

Comments