Problem with Export as ASCII

[vahid.mirhosseinian]

Hi, i have a Problem with Export my Data from DASYLab Version12 to Excel in Time Style.

When i use Timebasse frequence:

It's the Time in Excel like this,, 00:00,0'' instead of ,, 00:00:00''.

How can i fix it in DASYLab?

(I have no Problem when i use S or MS as Timebasse)

[CJ_Butler__DASYLab_Pro · Accepted solution]

This is a common problem with how Excel interprets time with fractional seconds. 

You have hh:mm:ss.000, but Excel shows you mm:ss.0 -- of course, replace the . (period) with , (comma) if necessary. 

You must format the cells (or the entire column) to use a Custom format -- I find that hh:mm:ss.000 works. 

Excel does not allow more than 3 decimals on the time format. If your sample rate is greater than 1000 samples/second, you should use the Seconds output, not the Time output. 

[vahid.mirhosseinian]

Thanks alot. I have to do it in Excel.