Calculate running pace per mile
=C2/B2Excel · result on the sample sheet: 5 rows (D2:D6)
Describe what you need and get a working TEXT formula for Excel and Google Sheets, tested on real data before you copy it. TEXT turns a number or date into text in the format you choose, such as "$1,250.00" or "March 2026".
Each formula below was calculated on its own sample sheet. Open one to see the sheet, why it works, and to try it yourself.
=C2/B2Excel · result on the sample sheet: 5 rows (D2:D6)
=(C2-B2)*24Excel · result on the sample sheet: 6 rows (D2:D7)
=TEXT(A2,"0")Excel · result on the sample sheet: 5 rows (B2:B6)
=TEXT(A2,"mmmm")Excel · result on the sample sheet: 5 rows (B2:B6)
=TEXT(A2,"00000")Excel · result on the sample sheet: 5 rows (B2:B6)
=B2&" is due on "&TEXT(C2,"mmm d, yyyy")Excel · result on the sample sheet: 4 rows (D2:D5)
=A2&" sales: "&TEXT(B2,"$#,##0")&" ("&TEXT(C2,"+0.0%;-0.0%")&")"Excel · result on the sample sheet: 4 rows (D2:D5)
=B2/C2Excel · result on the sample sheet: 5 rows (D2:D6)
You describe the task in plain English, and it writes the formula, using TEXT where that's the right tool, for your table or a sample one. The formula is run in our engine in Excel and Google Sheets mode before you see it, so you get its result, not just a guess.
TEXT turns a number or date into text in the format you choose, such as "$1,250.00" or "March 2026".
Yes. Each example below opens a page where you try the formula in a live grid and it's checked as you go, and the TEXT function page has a practice exercise.