CSV file in excel format displays incomplete

Question

I am using Python v2.7 on Windows 7 OS. My goal is using Python to generate a CSV file which contains date, time, etc.

The question is, the CSV outputs of time are different btw txt format and excel format. Here are some details.

If I use txt to open CSV file, it is good. The output is like: 2016-03-07,15:16:04.003000,...

But when I open the same CSV file with excel, the output of time is not fully displayed:
You may notice from the top line that, the full display of time is actually there. But from row 2, it is incomplete.

Please advice. Thanks!

format cells in excel file correspondingly: http://stackoverflow.com/questions/3095407/display-milliseconds-in-excel — MaxU - stand with Ukraine, Mar 07 '16 at 23:34
oops! http://www.mrexcel.com/forum/excel-questions/316511-can-i-display-time-up-microseconds-excel.html - you can show only milliseconds in Excel — MaxU - stand with Ukraine, Mar 07 '16 at 23:38
Thanks for the input. So is there a way to display full time? — Amber.G, Mar 07 '16 at 23:41
you can try to display it as a string, but you won't be able then to apply date/time formulas on that column — MaxU - stand with Ukraine, Mar 07 '16 at 23:44
Well...actually, the question I posted is coded under string~ :) we think the same, but problem is there anyway... :( — Amber.G, Mar 07 '16 at 23:48

score 1 · Answer 1 · answered Mar 07 '16 at 23:44

1

In Excel, select the "time value" cell and mouse right click --> Format Cell --> Number --> custom --> input Type as mm:ss.000000

Customize number display

answered Mar 07 '16 at 23:44

Yunhe

665
5
10

Thanks for the input Yunhe. I tried it out. The target is fully display 3:16:04. I customize the format on Format Cells, but it seems that only 16:04.### customized, I did see '3' in there... :'( – Amber.G Mar 07 '16 at 23:55
I think I figure it out, I just modify the last step on your idea. Thank you Yunhe! – Amber.G Mar 07 '16 at 23:58

score 0 · Answer 2 · answered Mar 07 '16 at 23:57

0

Problem solved by 'select the "time value" cell and mouse right click --> Format Cell --> Number --> custom --> input Type as h:mm.ss. Thanks for the hint from Yunhe!

answered Mar 07 '16 at 23:57

Amber.G

1,343
5
12
16

CSV file in excel format displays incomplete

2 Answers2