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.

--
Kevin Backmann


"Kevin B" wrote:


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...
--
Kevin Backmann


"Ann B" wrote:

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.