How can I write in a text in a cell using numbers and the letters.
 

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?

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?

Or start with an apostrophe:

'511E09

FYI:

511E09 looks like it's scientific notation to excel:
511 * 10^9
511 * 1,000,000,000



Sandy wrote:

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?

--

Dave Peterson