Maybe you could enter the value as text.

Precede your entry with an apostrophe: '12341234123412341234
or
preformat the cell(s) as text, then do the data entry.

bl wrote:

I am trying to enter this number(110727309194833644) into a cell but Excel
changes the number once I press the Tab key and makes it this
number(1.0727E+17), I need to have the above number in the cell not this
other number. How can I make Excel put the above number in the cell and not
automatically change it?
--
bl

--

Dave Peterson