View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Doug Kanter
 
Posts: n/a
Default Cell format changes when I paste

"robert111" wrote
in message ...

Format the receiving cell so that a "text" leading zero appears in front
of any number pasted in

eg "0"000


In Excel 2000, a simple paste function brings the copied format with it. Is
that not the case with later versions?