numbers need to be numbers

E:G are all number values in your file (ie COUNT(E:G) returns 72 as expected).

If it's D you need to change then highlight Column D and run Text to Columns -> Delimited - step 3 pick Date -> YMD and click Finish.

EDIT: ignore the above... I didn't look correctly !

As JB states replace the space with nothing (ie highlight data E2:G? and run Edit -> Replace replacing Char 160 (ALT + 0160) with nothing)