Troubleshooting: When dates shows up as numbers after uploading

Excel automatically recognizes dates and converts them to the Date format. When you upload the file, Quartzy views everything as Text, so it converts the dates into a text string. 

To solve this issue, you need to force the cells into Text format before you put dates into them:

1. Copy the dates from the Excel spreadsheet as they are (most likely they are in the "Date" format). 

2. Paste into a Word document doing a Paste Special -> Unformatted Text.

  

3. Go into the Quartzy Excel Template, select the whole column (A) and change the format of the whole column to Text (B).  

                                                         

 

4. Copy the dates from the Word document and do a Paste Special -> Text onto the Quartzy Excel Template in the appropriate column.

                                      

Note: Ignore the warning that "these look like dates, do you want to change the format" 

 

5. Upload the template to Quartzy. See the upload instructions here to make sure you have completed all steps correctly.

 

Next Up: Learn how to delete items in bulk using Excel

 

More questions? Contact us

Have more questions? Submit a request

Comments

  • Avatar
    Michelle Maynard

    if you simply had an apostrophe before your date ('9/30/2014) then format your excel cells to text instead of date it will upload to Quartzy in the correct format.

  • Avatar
    Monica Velarde

    Hi Michelle. That does appear to work! Thanks so much for sharing this idea here.