Navigation: Reference > Transforms >
Change units of time, length, temperature etc.
•Check the column(s) you wish to transform.
•Set Dimension to the dimensions of the units you wish to convert.
•Set From to the units you wish to convert from.
•Set To to the units you wish to convert to.
•The Locale set in the Preferences window is used to decide how the number is represented (e.g. decimal separators).
oYears are 365.25 days.
oCalories are thermal/small/gram (not nutritional) Calories.
oMiles are International/Statute Miles.
oNautical miles are International Nautical Miles.
oGallons (US) are liquid gallons.
oPints (US) are liquid pints.
•Warnings are shown in the Warnings tab for non-numeric values.
•Non-numerical and empty values are not changed.
•Use Copy Cols to copy columns before you transform them.
•Use Num Format to change the number format of the results.