How do I stop excel from displaying stings of numbers pasted or imported into
excel as a scientific equation? Like 5.73E+08 when the real part number is
549575667.
The data displayed in the formula bar is the correct full number but Excel
displays the data with the decimal and "+", it does this with imported data
from Monarch as well as just a cut and paste from another program.
If it is one or two number s I can retype directly and it will not happen
but I am pulling data lists with thousands of part numbers. This problems
seems worse now that I have Office 2007.
Any suggestions?