Excel gives me weird 5-digit numbers.

I'm having a weird problem. Numbers that are supposed to show up as "X.XX" for instance "1.05" from my DDE feed instead show up as some weird 5-digit numbers, like so "XXXXX.XX", for example "27395.00".
See attached picture for how it looks like.

I suspect it has to do with formatting, I tried to Format the cell and set it to "General", "numbers" and pretty much every option there is but it still shows up wrongly.