View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] mark@outofthisworld.com is offline
external usenet poster
 
Posts: 2
Default How to automatize this simple task on Excel?


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