12
Opening the Data File with Excel®
Depending on the region and language setting of your PC, measurement
data might be formatted incorrectly by Excel® when the data file is opened.
This is sometimes encountered with German set as the PC language,
as a German date format typically utilizes a decimal (DD.MM.YYYY).
The pH100M utilizes a decimal as the radix, so a temperature of
31.1
is
sometimes interpreted by Excel® as
31. Jan
when German is set as the PC
language.
If a data file is opened in Excel® and measurement data is incorrectly
interpreted as something other than a number, please follow these steps:
1. Open a blank Excel® spreadsheet.
2. Go to the
Data
tab and select
From Text
.
3. Choose to
Import
the data file you have copied to your PC. Don't
select the original data file that is still on the instrument.
4. Under Step 1 of the Text Import Wizard, choose
Delimited
.
5. Under Step 2 of the Text Import Wizard, choose
Semicolon
.
