Time stamp not written with milli sec value in spreadsheet file.

[Dskp]

Hi,

I am writing below 2 d array to  write spreadsheet VI .But when opened the spreasheet I couldnt able to find the  milli seconds.Please.

1.Attached the 2 d array,

2.Block diagram.

3. spreasheet view

[crossrulz]

This looks like it is just Excel playing format games with you.  Open the file with a text editor.  Is the miliseconds there?  If so, then you just need to change the format of how Excel is displaying the timestamps in those cells.

[Dskp]

Hi Crossrulz,

Yes..I edited in notepad and its shows me the milli seconds values.

Also ,I tried with some  excel formats to display time stamp with milli seconds value,but doest get anything good solution from internet.

Any idea on the excel format to dislay the milli seconds? please assist

[crossrulz · Accepted solution]

I just did something like this...

[Bob_Schor]

I'm sure you figured it out if you tried Crossrulz' suggestion, but if you want all three decimal positions, you need .000 in the Excel format string.

Bob Schor

[Dskp]

Hi Guys,

Yes.I got it with the  format suggested.

Thanks.

Dskp

[Bob_Schor]

It helps if you mark Crossrulz' post as the Solution (it both gives him credit and tells others with the same question where to go to find the answer).

BS