Clear the data, change it to text, and then enter it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Sandy" wrote in message
...
I'm trying to get some codes in for example 511E09 is one fo them but when
I
try to enter another code it makes the code a formula and it changes to
5.11E+09 why is that? I tried changing it by formatting cells to text,
but
that doesn't change it. Waht can I do?