Could very well be a separator problem.
Itsangad's suggestion is a good way to check what you really have loaded, but it will not solve you problem if there is a problem. To solve it you may need to use the Num#() function to interpret it correctly, e.g.
Num#( Field, '#', '.', ',') as InterpretedField