Without doing anything fancy, I think probably the easiest thing to do would
be to use Paste Special - Values Only. If pasted in that way, the new data
entry will follow the formatting of the columns. (Assuming that you
formatted the columns how you wanted it already).

" wrote:


Hi all,

I have an Excel sheet which I update (adding stuff at the bottom) via
the Windows clipboard.
I manually do "Format Cells / Numbers / 2 digits" each time on some
columns to fix them after paste. Is there a way to force a certain data
type and alignment on a column even if you paste unformatted text there?

Thanks a lot,
Marco