I have half-yearly data starting from June 2017 to June 2019. In excel wide format data it is written as x1 2017/06 x1 2017/12.....x12019/06 for example for x1 variable. When I import it to Stata and reshape to long, the time variable is not what it is actually. For example, 2017/06 is read as 1960h2 (second half of 1960). How do I write it in Excel so that it gets imported correctly or, anyway to fix it after import? Many thanks.