View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SAE SAE is offline
external usenet poster
 
Posts: 2
Default automaitcally changed text when copying

I created a master sheet. when copying dates to another worksheet in this
workbook it is changing the date to a number which is meaningless. i.e.
9/24/08 to 23498. I changed the formating to text and it didn't help. It
didn't work in date format either.