# Column formatting recipe steps


Use column formatting recipe steps to change the format of the data in your columns.

**Topics**
+ [

# NUMBER\$1FORMAT
](recipe-actions.NUMBER_FORMAT.md)
+ [

# FORMAT\$1PHONE\$1NUMBER
](recipe-actions.FORMAT_PHONE_NUMBER.md)

# NUMBER\$1FORMAT


Returns a column in which a numeric value is converted into a formatted string.

**Parameters**
+ `sourceColumn` – String. The name of an existing column.
+ `decimalPlaces` – Integer. The value of number of digits after the decimal separator.
+ `numericDecimalSeparator` – String. One of the following values indicating the decimal separator:
  + "."
  + ","
+ `numericThousandSeparator` – String. One of the following values indicating the thousand separator:
  + null. Indicates that a thousand separator isn't enabled.
  + ","
  + " "
  + "."
  + "\$1\$1"
+ `numericAbbreviatedUnit` – String. One of the following values indicating the abbreviation unit:
  + null. Indicates that an abbreviation unit isn't enabled.
  + “THOUSAND”
  + "MILLION"
  + "BILLION"
  + "TRILLION"
+ `numericUnitAbbreviation` – String. One of the following values or any custom value, indicating unit abbreviation:
  + null. Indicates that unit abbreviation isn't enabled.
  +     
[\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/databrew/latest/dg/recipe-actions.NUMBER_FORMAT.html)

**Example**  
  

```
{
    "RecipeAction": {
        "Operation": "NUMBER_FORMAT",
        "Parameters": {
            "sourceColumn": "income",
            "decimalPlaces": "2",
            "numericDecimalSeparator": ".",
            "numericThousandSeparator": ",",
            "numericAbbreviatedUnit": "THOUSAND",
            "numericUnitAbbreviation": "K"
        }
    }
}
```

# FORMAT\$1PHONE\$1NUMBER


Returns a column in which a phone number string is converted into a formatted value.

**Parameters**
+ `sourceColumn` – The name of an existing column.
+ `phoneNumberFormat` – The format to convert the phone number to. If no format is specified, the default is `E.164`, an internationally-recognized standard phone number format. Valid values include the following: 
  + `E164` (omit the period after `E`)
+ `defaultRegion` – A valid region code consisting of two or three uppercase letters that specifies the region for the phone number when no country code is present in the number itself. At most, one of `defaultRegion` or `defaultRegionColumn` can be provided.
+ `defaultRegionColumn` – The name of a column of the [advanced data type](projects.adv-data-types.md#projects.adv-data-types.title) `Country`. The region code from the specified column is used to determine the country code for the phone number when no country code is present in the number itself. At most, one of `defaultRegion` or `defaultRegionColumn` can be provided.

**Notes**
+ Inputs that can't be formatted to a valid phone number remain unmodified. 
+ If no default region is provided, and a phone number doesn't start with a plus symbol (\$1) and country calling code, the phone number isn't formatted.

**Example**  
  
**Example: Fixed default region**  

```
{
    "Action": {
        "Operation": "FORMAT_PHONE_NUMBER",
        "Parameters": {
            "sourceColumn": "Phone Number",
            "defaultRegion": "US"
        }
    }
}
```
**Example: Default region column option**  

```
{
    "Action": {
        "Operation": "FORMAT_PHONE_NUMBER",
        "Parameters": {
            "sourceColumn": "Phone Number",
            "defaultRegionColumn": "Country Code"
        }
    }
}
```