Convert

convertThis Analytics Edge wizard is used to convert columns from one data type (text, number, or date) into another. It can also convert to a variant of the same type, like converting dates to first of the month.

Typically used to force imported data into the correct type (such as dates with odd formats), it can also be used to convert dates and numbers into specific formats for reporting purposes.

Select Column – select a column in the list, shown with the column letter for position reference or optionally By Name, then click the Next button to choose options. Depending on the type of column, you will be given additional options to convert the selected column from text, number or date formats into different text, number or date formats. You will be redirected back here, where you can either convert another column or click Finish.

Note that you can convert within a type, such as truncating text, rounding numbers, and converting to first of the month.

convert-t2tText to Text

Check at least one option and click the Next button to return to the column selection list.

convert-t2nText to Number

You can get a number from a textual representation of a number from a different culture, such as with a different decimal separator.

You can also extract just the digits from any text.

convert-text to dateText to Date

If dates are provided in unrecognizable forms or as text strings, enter date-part codes to match the format.

You can also convert from/to GMT or local time zone.

convert-n2tNumber to Text

Useful for presenting numbers as text strings in a specific way. Enter format codes or select a culture.

Culture selection determines thousands and decimal separators.

convert-n2nNumber to Number

Round the number to the specified number of decimal places, or round it to the nearest hundreds or thousands as required.

convert-n2dNumber to Date

Convert the number into a date, assuming the original number was an Excel date serial number (internal representation), the number of days since a specific date, or one of several day-of selections.

convert-date to textDate to Text

Create a text string representation of the date with a specific format by entering the date-part codes desired.

You can also convert from/to GMT or local time zone.

convert-d2nDate to Number

Convert the date to an Excel serial number (internal representation of dates), the number of days since a specific date, or one of several day-of selections.

convert-date to dateDate to Date

Shift the date to the first of the month, drop the time element, or keep only the time element.

You can also convert from/to GMT and the local time zone.