Hi,

pre-format as text or enter an apostrophe ' before you type the number.

Mike

"deva" wrote:

when i m writing 123456789123456789 in a cell. it is getting changed into
1.23457E+17. why? i want to write it without any change