This sounds like a repeat of Mixed Column Data Types - converts data incorrectly . Did my solution there not work?
@dmitry-grist the problem is a large float in a numeric column is formatted by Grist as scientific notation when converting to text. Might help if the type was guessed as integer instead of numeric.