Sep 21 2020 12:38 PM
excel shows hh:mm:ss am/pm. i need only HH:MM. when i change and even lock cells, save as csv, and reopen the format returns to hh:mm:ss am/pm
can anyone help me find a solution
many thanks
Sep 21 2020 12:44 PM
CSV is actually text file, it doesn't keep formatting. When you open it Excel applies you default format. You may check it and change if necessary in date and time settings of Windows. That's
Win+R
control international