title: Excel vba - changing format to date, but can't sort it
body: <p>I changed the format of range of cells to date like this: <code>.NumberFormat = "dd.mm.yyyy"</code>. But when I right click those cells I get that format is custom (and its in dd.mm.yyyy), and when I try to sort that range, I can't sort it Oldest To Newest, just A-Z.</p>
  
  <p>And second question. What is the difference in lines  <code>.NumberFormat = "dd.mm.yyyy;@"</code> and <code>.NumberFormat = "dd.mm.yyyy"</code></p>