FormulaCraft

TEXT

TEXT converts a number or date into formatted text — percentages, currency, leading zeros, or date strings — so you can display or join it exactly how you want.

Excel
=TEXT(A2, "0.00%")
Google Sheets
=TEXT(A2, "0.00%")

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1A2 is the value to format.
  2. 2"0.00%" is the format pattern.
  3. 3Common patterns: "0.00" for decimals, "$#,##0" for currency, "yyyy-mm-dd" for dates.

Need a version for your data?

Try: “Show the number in A2 as a percentage with two decimals”

Related

TEXTJOINLEFT / RIGHT / MIDTRIM

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: