In Excel I type 24E1 in a cell it changes ...

  • Thread starter Thread starter Ann B
  • Start date Start date
A

Ann B

even when I put the formatting as General. No matter what it keeps going
back to Scientific format afterwards. Help? This is a branch code I need in
this spreadsheet for import into a HRIS system.
 
Ann

Type an apostrophe ' and then the branch code 24E1 and all should be OK.

Mike
 
Either format the cell as text, or precede the 24E1 with an apostrophe.
 
Either format the cells before hand as TEXT format, or when entering any
thing that can be construed as a number, use an apostrophe as a prefix to
your entry to make it text.

Hope this helps...
 
Precede the entry with an apostrophe or pre-format the cell as TEXT.
 
Thank you both for your helpful answers. Why was it doing that? I always
like to know the reasons behind things just in case I come across it again in
a different but similar situation? What in the Scientific functions would
that be interpeting?
 
Your entry of 24E1 was treated as a number entered in scientific notation.
Hence the value transformation when it was not entered a label or entered
into a cell formatted as text.
 
You must log in or register to reply here.

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

Entering 'GTi' but I get 'Gti' ! 2
Stop XL from changing format? 1
How do I stop Excel 2007 from using scientific notation? 2
how can I save an excel file with long number columns in cvs form. 3
Cell Formating Excel 1
when I type numbers in a cell it changes it to a decimal point 4
Text displayed as # in cell 2
Change Style Dropdown 1

Back
Top