Just saw this post, the problem is caused by the fact the imported data is text format, not numeric format used by Chat.
The quick fix is to use "Replace All" to replace "." with ".", i.e. to replace a dot with a dot as a decimal point.