View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pkeegs pkeegs is offline
external usenet poster
 
Posts: 46
Default Entering dates in vba inputbox as ddmmyy. Excel returns mmddyy

I am using an inputbox in VBA to return a date into an excel cell. When I
enter the date as dd mm yy, excel returns it as mm dd yy, irrespective of how
I have formatted the receiving cell. It only applies to the lower numbers
such as 06/07/05. If I were to enter 25/07/05, it would return correctly.