Pre-format the column to 'Text'.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"KB" wrote in message
...
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?