EasyManua.ls Logo

Hydac FCU 1310 - The Measurements Are Shown as Dates

Hydac FCU 1310
124 pages
Print Icon
To Next Page IconTo Next Page
To Next Page IconTo Next Page
To Previous Page IconTo Previous Page
To Previous Page IconTo Previous Page
Loading...
Evaluating measurement records
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
< Bac k
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
< Bac k
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
< Bac k
Data format of the columns
Text conversion assistant - step 3 of 3
Other
Standard
Text
Do not import column
Date
Decimal separator:
Other text import settings
1000s separator:
OK
Cancel
Reset
Delimiter used for numeric data:
FCU1310
en(us)
Page 80 / 124
BeWa FCU1310 V300 3371346f en-us 2017-01-27.docx 2017-01-27

Table of Contents