View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Patrick C. Simonds Patrick C. Simonds is offline
external usenet poster
 
Posts: 343
Default Paste year as a specific date

Can anyone think of a way in which someone could enter a number
(representing a year, say 2009) and then paste the results into cell A1 as
January 1 of that year?