---
title: "Reformatting Phone Numbers"
slug: "reformatting-phone-numbers-in-exports-reports"
updated: 2025-11-25T21:59:17Z
published: 2025-11-25T21:59:17Z
canonical: "knowledge.technolutions.net/reformatting-phone-numbers-in-exports-reports"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://knowledge.technolutions.net/llms.txt
> Use this file to discover all available pages before exploring further.

# Reformatting Phone Numbers

Slate formats phone numbers based on each country's official formatting standards.

- For a USA phone number, that is `+1 000-000-0000`.
- For a UK phone number, that might be `+44 00 0000 0000` (spaces in specific segments, no hyphens).

You don't need to worry about trying to format phone numbers at the time of data capture; reformatting a phone number is a [data export](/v1/docs/building-data-export-query) and [reporting](/v1/docs/reports) consideration.

To apply different formatting in a query or report, add exports to a [query library](/v1/docs/query-library) that use a custom SQL format type or a [formula type](/v1/docs/using-formulas-in-queries).

Example formula:

```sql
(case when (@val like '+1 %') then stuff(stuff(@val, 4, 0, '('), 8, 1, ') ') else @val end)
```

[![](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/10988193022619.png?sv=2026-02-06&spr=https&st=2026-11-10T13%3A22%3A05Z&se=2026-11-10T14%3A22%3A05Z&sr=c&sp=r&sig=D%2FtG7Gd4%2BTFXVsRGjPDHNM%2FoyDcS%2FokQW1JUWGF102U%3D)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/10988193022619.png?sv=2026-02-06&spr=https&st=2026-11-10T13%3A22%3A05Z&se=2026-11-10T14%3A22%3A05Z&sr=c&sp=r&sig=D%2FtG7Gd4%2BTFXVsRGjPDHNM%2FoyDcS%2FokQW1JUWGF102U%3D)

Example results:

[![](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/10988052677275.png?sv=2026-02-06&spr=https&st=2026-11-10T13%3A22%3A05Z&se=2026-11-10T14%3A22%3A05Z&sr=c&sp=r&sig=D%2FtG7Gd4%2BTFXVsRGjPDHNM%2FoyDcS%2FokQW1JUWGF102U%3D)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/10988052677275.png?sv=2026-02-06&spr=https&st=2026-11-10T13%3A22%3A05Z&se=2026-11-10T14%3A22%3A05Z&sr=c&sp=r&sig=D%2FtG7Gd4%2BTFXVsRGjPDHNM%2FoyDcS%2FokQW1JUWGF102U%3D)

If it's in a query library, you won't have to do this each time; you'll get the desired formatting whenever you add that export.

You will still store the phone number with the official formatting, and other systems that might need a phone number fed to them might require even a different format (such as E.164, which has no spaces or hyphens), so there's no one-size-fits-all type of formatting for these.