Thread: Copy Date on Excel Tab to Cell In Spreadsheet and Add Year, How?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] aep002@cox.net is offline
external usenet poster
  
Posts: 3
Default Copy Date on Excel Tab to Cell In Spreadsheet and Add Year, How?
I work on bank reconciliations and the tabs say "7-19", "7-18" etc.
Figured out how to auto copy the tab data but how can I add to it so it
reads "7-19-06"?

THANKS!!!

Reply With QuoteReply With Quote