View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Typing an "E" within numbers changes cell

Preformat the cell as text, then make your change.



Access Joe wrote:

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


--

Dave Peterson