I work for a company that is implementing a new chart of accounts to
manage our business. The new account length will be 12 characters in
length(e.g. 611500100001). Unfortunately, when this is entered in
Excel - Excel automatically changes the value to an exponent
(6.115E+11).
Now I know I can change the format to display the number correctly, but
actually want to either change the default exponent length setting or
worse case: remove the exponent feature altogether. One of the other
reasons that this will become a big problem is the fact that in my
company we utilize CSV (comma separated value) files extensively and we
modify it using Excel. Everytime a CSV file is opened all of the
accounts are changed to exponents.
Does anyone know of anyway to change excel's default setting for
switching a number to an exponent? If not, I'd even entertain the
thought of removing the exponent entirely from Excel as it will become
that big of a problem.
Thanks in advance for any feedback!

Rich S