DataFormatError Details meaning

[Anonymous]

I'm merging two tables and receiving the following error:

Here is a snippet of the tables and the columns I'm joining on: 

1: an abbreviation code

2: and ID (no, not unique)

3: date time value

My question is, what exactly does the "Details: 10035-10036" in the error mean? How can I find which column is throwing that error after the join?

The merge is successful, but when I click to expand the columns, then I get this error. 

[Ashish_Mathur · Accepted solution]

Hi,

A column which you have formatted as Number has an entry 10035-10036.  Since this entry cannot be converted into a number, you get an error.  Just under the heading, a red horizontal line shoud tell you that there is an error in that column.