The cell is formatted as GENERAL just like all the other cells in this column.
Most of these cells are filled with data like KS123456GB but i am now wanting to type this 5614930256506582
The problem i face is as soon as i leave the cell its format is changed to scientific 5.61E+15
Why ???