Try this formula

=TEXT(A1,"#")

Row\Col
A
B
1
2.09784E+14
209784209720429
2
1.23457E+15
1234567891011120
3
2.09784E+14
209784209720429


or you can also format cells: Custom, and enter #