how do I format alphanumeric numbers in excel?

Q

quinn111

I cannot get General formatting to work with a number such as 98E195.
The width is plenty big enough, but the display shows 9.8E+196.

What can I do to get this to display correctly?
 
S

Susan Carrier

There are 2 ways to solve this. The first way is to format the cells as TEXT
before you enter your data. This will prevent Excel from trying to
"translate" the text into a number in scientific notation.

The second method is to place an apostrophy ' in front of the text as you
type it. This will tell Excel that the content is a label and not a value.
The ' will not show in the cell, but will appear in the formula bar when the
cell is active.

Susan Carrier
 

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

Excel does not accept text format! 0
Paragraph numbering in Word 1
Inconsistent formatting of section numbers 0
How can the font and size of (all) citation numbers be altered? 1
Outlook 365 overriding formatting choices 0
Word not picking up secondary excel identifiers (Alphanumerical numbers) 0
VBA code in Excel opens Word template and fills bookmarks, but can't get correct formatting 5
Excel is converting my alphanumeric text to scientific notation 2

Top