time format wont change

%3CLINGO-SUB%20id%3D%22lingo-sub-1694573%22%20slang%3D%22en-US%22%3Etime%20format%20wont%20change%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1694573%22%20slang%3D%22en-US%22%3E%3CP%3Eexcel%20shows%20hh%3Amm%3Ass%20am%2Fpm.%20i%20need%20only%20HH%3AMM.%20when%20i%20change%20and%20even%20lock%20cells%2C%20save%20as%20csv%2C%20and%20reopen%20the%20format%20returns%20to%20hh%3Amm%3Ass%20am%2Fpm%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ecan%20anyone%20help%20me%20find%20a%20solution%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Emany%20thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1694573%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1694661%22%20slang%3D%22en-US%22%3ERe%3A%20time%20format%20wont%20change%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1694661%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F801975%22%20target%3D%22_blank%22%3E%40charlie2020%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECSV%20is%20actually%20text%20file%2C%20it%20doesn't%20keep%20formatting.%20When%20you%20open%20it%20Excel%20applies%20you%20default%20format.%20You%20may%20check%20it%20and%20change%20if%20necessary%20in%20date%20and%20time%20settings%20of%20Windows.%20That's%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWin%2BR%3C%2FP%3E%0A%3CP%3Econtrol%20international%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

1 Reply

@charlie2020 

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