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?

Precede the data with a single quote like this:

'511E09

Hope this helps,
theDude

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

--

HTH

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


"Sandy" <Sandy@discussions.microsoft.com> wrote in message
news:9C474C50-E47D-43EB-A4F0-B4D21141E39F@microsoft.com...
> 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