Or, how to edit gmail csv-file (which was exported from gmail) with correct way …
convert the time in A1 to text.
code, which use for macro in excel
for Excel 2010
The following macro will enter the current date and time in the active cell without moving the cursor. The date and time will be entered as a datevalue, meaning that it will not change every time you open the workbook.