Thread: create date
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MartinW MartinW is offline
external usenet poster
 
Posts: 860
Default create date

Hi Tom,

In C1 put =(A1&"/"&B1)*1 and format C1
as custom mmm-yyyy

HTH
Martin