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

G

Guest

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?
 
B

Bob Phillips

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

--

HTH

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

Dave Peterson

Or start with an apostrophe:

'511E09

FYI:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete Duplicate codes in a cell 1
Changing Text To Numbers ? 1
Text to Columns Letters and Numbers 5
Splitting text and numbers from a cell 6
Last Modified By in a cell by user 3
Numbers change in cell even when formatted as text 4
Excel How to add numbers in same cell? 2
separate letters from cell 4

Top