title: pasting dd/mm/yyyy dates in google sheets
body: <p>In a text file I have date column as dd/mm/yyyy but when I am pasting the same as it is (paste as values) to google sheets, google sheets converts that to mm/dd/yyyy. That means, 07/06/2017 becomes 06 July and 22/12/2017 becomes invalid dates. I am having to manually change that. </p>
  
  <p>What is the way to force google sheets to stop auto converting dd/mm/yyyy to mm/dd/yyyy ?</p>
  
  <p>Thanks
  Kunal</p>