---
schema_version: "1"
id: baf2ff33f8a400d40dd0c2855e56748ebea88b32e5261e5b01b4de96bf628620
title: FORMAT() Function Workarounds in Tableau
collection: tableau
version: next
locale: en-gb
portal_url: https://docs.salesforce.com/tableau/next/en-gb/pro/desktop/format_fields.md
canonical_url: https://help.tableau.com/v0.0/pro/desktop/en-gb/format_fields.htm
source_site: help.tableau.com
content_type: documentation
content_hash: c57a45b2ac89e3a4f6adabb68458cd2cd50c97263e8d1a931a54d2a5eca343c7
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/v0.0/pro/desktop/en-gb/maps_geographicroles.htm).
- Date or number fields, see [Set the default number format](https://help.tableau.com/v0.0/pro/desktop/en-gb/datafields_fieldproperties.htm#DefFormat).
    - Custom date formats, see [Custom Date Formats](https://help.tableau.com/v0.0/pro/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/v0.0/pro/desktop/en-gb/functions_operators.htm#literals).
- Numbers and null values, see [Format Numbers and Null Values](https://help.tableau.com/v0.0/pro/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/v0.0/pro/desktop/en-gb/functions_functions_string.htm).