I have a csv file that contains data in this format:

2016-03-09 08:28:24.000;1012.49
2016-03-09 08:28:24.333;1000.08
2016-03-09 08:28:24.666;1014.08
2016-03-09 08:28:24.999;1018.64
2016-03-09 08:28:25.333;999.7

If I open this file with excel, the milliseconds are cut off like this: enter image description here

(The values under B are not the milliseconds. They are just corresponding values.)

I tried to format it as text, but this returns just one long number, like this: enter image description here

I also tried a custom format as suggested in the answer to StackOverflow / Display milliseconds in Excel

But this does not disply the actual milliseconds, it just displays '000' where the right milliseconds should be.

How do I get excel to format my data right?

  • the issue is not only the number formatting, but also that Excel considers milliseconds to be in a different column. You either need to manage that during input to tell Excel that those should be in the same column. Or you need to add the two columns: A2+TIME(0,0,B2/1000) Commented Mar 10, 2016 at 12:13
  • When you are importing the csv file it is using ; as a separator. You need to use another character, , for example.
    – DavidPostill
    Commented Mar 10, 2016 at 12:20
  • Sorry, this is a missunderstanding. The number after the ';' is a seperate value. The ';' as the seperator is not the problem. Commented Mar 10, 2016 at 12:42


You must log in to answer this question.

Browse other questions tagged .