Typing an "E" within numbers changes cell

A

Access Joe

Hey everyone,

When I type an "E" within a cell that contains numbers, it changes the
formatting of it to scientific notation. For example, when I type "541e08",
it changes to "5.41E+10". Is there a way to prevent this from happening
WITHOUT having to type an apostrophe before the entry?

Thanks everyone. AccessJoe
 

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

Pasting large numbers as text in Excel 5
Sorting data with the letter 'E' included 3
Excel autoformatting dates 1
Hex numbers displayed in scientific notation when importing text f 2
Highlight Changes within cell 1
Highlight changes within cell 1
Numeric Format Changes From 1 Cell to the Next? 2
Last Modified By in a cell by user 3

Top