Evaluating stored records
SensorMonitoring Unit - SMU
en(us)
Page 84 / 100
BeWa SMU1200 3854281 V2.0x en(us) 2013-08-20
2013-08-20
The measurements are shown as dates
On opening the file, all decimal numbers will be shown as dates. To resolve
this, proceed as follows:
1. Start Excel.
2. From the menu bar, select the
"Open" command.
Open the measurement file.
3. The
Text conversion assistant - step
1 of 3.
Check the settings.
Press the "Continue >" button to
accept the settings.
4. Text conversion assistant step 2
of 3
Check the settings.
Press the "Continue >" button to
accept the settings.
5. Text conversion assistant - step
3 of 3.
Press the "Other" button.
6. Change the following settings:
Set the decimal separator to be
a dot and the 1000s separator to
be a comma.
Confirm the changes with the
Separated
Fixed width
Continue >
Finish
Cancel
< Back
Original data type
Select the data type that best describes your data:
Import starts in line:
Source of file:
Text conversion assistant - step 1 of 3
Tab stop
Preview of the marked data
Continue >
Finish
Cancel
< Back
Treat adjacent delimiters as a character
Delimiter
Text recognition character:
Text conversion assistant - step 2 of 3
Space
Semicolon
Other:
Comma
Preview of the marked data
Continue >
Finish
Cancel
< Back
Data format of the columns
Text conversion assistant - step 3 of 3
Other
Standard
Text
Do not import columns
Date
Decimal separator:
Other text import settings
1000s separator:
OK
Cancel
Reset
Delimiter used for numeric data:
