---
schema_version: "1"
id: 28818d0fc07a8f1ce062f5e16337720fd8dd820757c7bbe2f280dbcc9338cb99
title: FORMAT() Function Workarounds in Tableau
collection: tableau
version: current
locale: en-gb
portal_url: https://docs.salesforce.com/tableau/current/en-gb/public/desktop/format_fields.md
canonical_url: https://help.tableau.com/current/public/desktop/en-gb/format_fields.htm
source_site: help.tableau.com
content_type: documentation
content_hash: e6e572bc2697dd4378b2fd8f5644788e24e72548f29819dc7ef97fdaaceb75cd
description: Use workarounds for formatting fields since Tableau has no FORMAT() function.
---
[Skip to main content](#main-content)

# FORMAT() Function Workarounds in Tableau

Tableau has no FORMAT() function for formatting fields, but it does provide a variety of means to change the structure and appearance of fields in a workbook:

- Geographic fields, see [Assign Geographic Roles](https://help.tableau.com/current/public/desktop/en-gb/maps_geographicroles.htm).
- Date or number fields, see [Set the default number format](https://help.tableau.com/current/public/desktop/en-gb/datafields_fieldproperties.htm#DefFormat).
    - Custom date formats, see [Custom Date Formats](https://help.tableau.com/current/public/desktop/en-gb/dates_custom_date_formats.htm).
- Symbols and conventions that you can use to specify field formats, see [Literal expression syntax](https://help.tableau.com/current/public/desktop/en-gb/functions_operators.htm#literals).
- Numbers and null values, see [Format Numbers and Null Values](https://help.tableau.com/current/public/desktop/en-gb/formatting_specific_numbers.htm).

Tableau also provides a range of string functions that you can use to customise the appearance of string fields in a view. See [String Functions](https://help.tableau.com/current/public/desktop/en-gb/functions_functions_string.htm).