View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jules Jules is offline
external usenet poster
 
Posts: 86
Default format a date - linked from different tab

I have one tab pulling in dates from another tab on a worksheet. But I am
unable to format the dates as every time I refresh the data, the dates (that
are pulled from the other tab) revert back to their own formatting. Some
read with a time, some as 1/1/08, some as 1-Jan-08? What is wrong?