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.