DOLLAR Function in Excel: Number as Currency Text

⏱ 1 min readUpdated 28 September 2026

TextLevel: IntermediateAvailable in: Excel 2007+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. Related functions

DOLLAR formats a number as currency text using your computer’s currency symbol. The name is historic — on an Indian-locale PC it shows ₹.

Syntax

=DOLLAR(number, [decimals])
Argument What it means
decimals Default 2.

Examples

Example 1

="Balance "&DOLLAR(C5)

Balance ₹12,400.00 on an Indian-locale PC.

TEXT · FIXED

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Keep reading

Excel Functions A–ZWORKDAY Function in Excel: A Date N Working Days AwayExcel Functions A–ZNORM.S.DIST Function in Excel: Standard Normal ProbabilityExcel Functions A–ZSHEETS Function in Excel: How Many Sheets?
✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong