I understand anything over 15 #'s is too large and I know how to change it,
but I can only do it for the present numbers in a column. Any future numbers
I paste into the column keeps reverting to something like 2.500013E+11. I am
looking to format the column for future pastes. I know if you type the '
will work but how can I format that in the column for future pastes?