How to automatize this simple task on Excel?

[mark]

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

 

[Laroche J]

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

Yes. Instead of selecting a group of cells to format, click on the column
(letter) header to select the whole column, then apply the formatting.

JL
Mac OS X 10.4.11, Office v.X 10.1.9