I cannot reproduce this behaviour - maybe it depends on the source from
which you are copying. Try making the columns a fixed width before pasting.
Just an idea.
best wsihes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jeff" wrote in message
...
I am using Excel 2007 and often cut and paste data in number and scientific
number format. The problem is that Excel will often decide that I need to
see a large number of numbers after the decimal place and will change the
width of the columns to fit that many numbers. I am working with a lot of
data and so I would prefer to keep all of my columns at a set width of
8.43
to reduce the clutter. It becomes really annoying to have to change the
column widths back to the size that I want each time I add new data.

Can anyone please tell me how to stop Excel from automatically changing
the
column width each time new data is entered?

Thank you.