title: how to prevent excel 2010 from converting times to decimals automatically when cell is pasted
body: <p>As you might have come accross, MS Excel tends to convert times to decimal values. I do want it to convert the values automatically because I need the time value. Suppose I have following data:</p>
  
  <p>Departure | Time</p>
  
  <p>Istanbul    06:45
  Ankara      01:30</p>
  
  <p>I am using <strong>Concatenate</strong> function to create a desired string as <strong>Istanbul: 08:00</strong> and <strong>Ankara: 18:30</strong>. However, when I use the formula, Excel converts hours to decimals and I get <strong>Istanbul: 0.28125</strong> and <strong>Ankara: 0.0625</strong>. I do not want it to convert. How can I do this? </p>
  
  <p>ps: This also happens when I copy time values from Excel to Notepad++. Moreover, when I import time values into PostgreSQL through add-in, I still get decimal values in the columns</p>