Revision history [back]

Hi Julien,

Thanks very much for the quick reply (and also the Excel Macro, without it we wouldn't be able to do the analysis!).

Yesterday we already had the data in Excel with a decimal point and ran the Macro on it which didn't give us the data in the IDF Editor in the correct format.

I tried the following: 1) Running the Macro on the Excel Data with a decimal point 2) Running the Macro on the Excel Data with a decimal point while also changing system seperator in Excel Settings 3) Running the Macro on the Excel Data with a decimal point and formatting the Number Format to i) General; ii) Number and also tried iii) Text 4) Running the Macro on the Excel Data with a comma

I have attached a screenshot of the Excel and a screenshot of the IDF Editor. In the IDF Editor it give us the number format either in "," or it separates the 0.5 into two rows (Row 1: 0 and Row 2: 5). See screenshot.C:\fakepath\IDF Editor.png(/upfiles/1524732203925445.png)

We arer really clueless.. have you got any other ideas?

We would highly appreciate any support :-).

Best regards, Roger

Hi Julien,

Thanks very much for the quick reply (and also the Excel Macro, without it we wouldn't be able to do the analysis!).

Yesterday we already had the data in Excel with a decimal point and ran the Macro on it which didn't give us the data in the IDF Editor in the correct format.

C:\fakepath\Excel Screenshot.png We arer really clueless.. have you got any other ideas?

We would highly appreciate any support :-).

Best regards, Roger