View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pamble pamble is offline
external usenet poster
 
Posts: 1
Default Formats-Paste special

I have tried unsuccessfully to format a date in a column by copying the
actual date then using paste special to format in Month-YY format. When I
use that column in a pivot table the formatting reverts back to the date even
after paste special. How can I make the formatting stay?? HELP