What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Some links on this page are affiliate links: if you buy through them we may earn a commission, at no extra cost to you.
Currency formatting changes how a number looks; it does not convert the amount or change the underlying value. For example, the number 1234.5 can appear as $1,234.50, 1.234,50 €, or ￥1,235, depending on the currency and locale. In Excel, select the cells and choose Home → Number → Currency or Accounting. In Google Sheets, use Format → Number → Currency. In JavaScript, use Intl.NumberFormat with a locale and currency code.
Formatting, conversion, rounding, and storage are different
Formatting is a presentation choice. It adds a currency symbol or code, grouping separators, decimal places, and a negative-number style to a numeric value. It does not establish which currency the number represents or convert it at an exchange rate. Showing a number as dollars is not the same as converting euros into dollars.
Keep the amount and its currency code as separate data when accuracy matters. A symbol such as $ can mean USD, CAD, AUD, NZD, SGD, HKD, and other currencies. In a mixed-currency table or an international interface, use a clear code such as USD or CAD where the symbol alone could confuse readers.
Rounding also deserves separate attention. A display that shows two decimal places may hide a value stored with greater precision. Display precision, calculation precision, and any transaction or accounting rounding rule are not automatically the same.
#1 Best Overall
- The Microsoft Office 365 Bible: The Most Updated and Complete Guide to Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Teams, Access, and Publisher from Beginners to Advanced
- ABIS BOOK
Choose Currency or Accounting presentation
| Format | Best suited to | Typical presentation |
|---|---|---|
| Currency | Prices, invoices, product lists, and customer-facing totals | The symbol sits close to the amount; decimal places and negative styles can be selected. |
| Accounting | Budgets, financial statements, and columns of amounts | Symbols and decimal points align; zero may appear as a dash and negatives may appear in parentheses. |
Neither style is inherently more accurate. Choose Currency when each amount should read naturally on its own; choose Accounting when consistent alignment across a financial column matters. In Excel, some negative-number options are unavailable under Accounting because it follows a more standardized accounting layout. Microsoft explains the Excel Currency and Accounting formats.
Format currency in Excel desktop
Apply a quick format
- Select the numeric cells you want to format.
- On the Home tab, find the Number group and choose Currency or Accounting.
- For a quick Currency format, use
Ctrl+Shift+$. On Mac, keyboard shortcuts can differ by keyboard and Excel version; use the Number controls if that shortcut does not apply.
Set a currency, decimals, or negative style
- Select the cells and press
Ctrl+1to open Format Cells. - Choose Currency or Accounting.
- Set the decimal places and select the desired currency symbol. For Currency, choose an available negative-number style if needed.
- Apply the format and check the result against positive, negative, zero, and fractional values in the column.
To remove a currency display format while retaining the cell value, select the cells and choose General from the Number controls. Excel’s documented steps and controls apply to Microsoft 365, Excel for Mac, Excel 2024, Excel 2021, Excel 2019, and Excel 2016. See Microsoft’s Excel currency-format instructions.
Excel for the web
Excel for the web supports Currency and Accounting formats. Microsoft says the default dollar currency symbol cannot currently be changed directly in the web app. To specify that default symbol, open the workbook in desktop Excel, make the change there, save it, and reopen it on the web. Details are in Microsoft’s Excel for the web guidance.
Recommended Free Tools
Format currency in Google Sheets
Apply a standard or custom currency
- Select the cells.
- Choose Format → Number → Currency for the spreadsheet’s default currency format.
- For another currency, choose Format → Number → Custom currency, search for the currency, adjust available properties such as decimal places, and select Apply.
For a display that standard formats do not provide, use Format → Number → Custom number format. Sheets custom formats can have up to four semicolon-separated sections for positive values, negative values, zero, and non-numeric values. For example, $#,##0.00;[Red]($#,##0.00);- is a pattern for two decimal places, red parenthesized negatives, and a dash for zero. The exact appearance depends on the sheet’s locale, so verify the pattern in the target spreadsheet. Google documents these options at Format numbers in Google Sheets.
Set the spreadsheet locale
- Choose File → Settings.
- Under General, change Locale; change the time zone too if required.
- Select Save settings.
The locale affects default currency, date, and number formatting for the spreadsheet and applies to collaborators viewing it. It changes presentation defaults, not the economic value of a number. See Google’s spreadsheet location and calculation settings guidance.
Use the DOLLAR function only when text is wanted
=DOLLAR(1234.5, 2) creates a locale-formatted currency string with two decimal places. The function returns text, not a numeric cell with a display format. Use cell formatting instead when the result needs to remain numeric for sorting, formulas, or further calculations. The syntax and behavior are documented in Google’s DOLLAR function reference.
These menu paths are for the desktop interface. Google Sheets has separate formatting instructions for Android and iPhone and iPad; do not assume every desktop control appears in the same place on mobile.
The Tool Desk
Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →Format currency in JavaScript
Use the built-in Intl.NumberFormat API rather than attaching a hard-coded symbol to a number. Supply both a locale and an ISO-style currency code:
const amount = 1234.5;
const formatted = new Intl.NumberFormat("en-US", {
style: "currency",
currency: "USD"
}).format(amount);
console.log(formatted); // $1,234.50The locale determines details such as symbol placement, grouping, decimal separator, and spacing. The currency code identifies the currency and is required with style: "currency". For example:
new Intl.NumberFormat("de-DE", {
style: "currency",
currency: "EUR"
}).format(1234.5); // 1.234,50 €
new Intl.NumberFormat("ja-JP", {
style: "currency",
currency: "JPY"
}).format(1234.5); // ï¿¥1,235Options can alter the display without changing the value:
const formatter = new Intl.NumberFormat("en-US", {
style: "currency",
currency: "USD",
currencyDisplay: "code",
currencySign: "accounting",
minimumFractionDigits: 2,
maximumFractionDigits: 2
});
formatter.format(-1234.5); // (USD 1,234.50)currencyDisplay can use a symbol, code, or currency name; currencySign: "accounting" requests an accounting-style negative pattern where the locale supports it. Explicit fraction-digit settings override the formatter’s ordinary currency precision, so set them only when the application’s requirements call for it. Locale-aware patterns and currency forms are described in the Unicode CLDR number specification.
Do these 3 things before closing this tab:
1Fix the driver behind crashes, sound loss and screen glitches2Clear out junk files and repair common Windows errors3Scan for outdated or missing drivers - takes under a minuteAccount for locale and currency precision
Currency output varies by locale: separators may differ, the symbol may come before or after the number, spacing can change, and negative values can use different signs or parentheses. For instance, $1,234.56, 1.234,56 €, and 1 234,56 € are not interchangeable text patterns. A comma does not universally mean thousands, and a period does not universally mean decimals. Microsoft describes locale-specific conventions and exceptions in its guidance on currency formats and number formatting.
Rank #4
Do not force two fractional digits for every currency. USD is commonly displayed with two; JPY is commonly displayed with none, and some currencies use three. Follow the currency’s ordinary fraction convention unless a documented business requirement specifies otherwise. A formatter presents the supplied value; it does not decide whether the amount, its precision, or a transaction’s rounding rule is economically or legally correct.
For software, keep a structured amount and currency code rather than storing a finished string such as $1,234.50 as the only representation. Financial applications may use integer minor units or decimal arithmetic to avoid binary floating-point representation issues. The right storage and arithmetic design depends on the application; a display formatter is not a money-calculation system.
Troubleshoot common currency-format problems
Formulas or sorting do not treat amounts as numbers
The cells may contain text such as $1,234.50, not numeric values with a currency format. Formatting cannot turn arbitrary text into reliable numeric data. Convert or parse the input into a number using the intended locale, then apply a display format. In Google Sheets, remember that DOLLAR returns text.
The wrong symbol or separators appear
Check the selected currency and the spreadsheet or application locale. A locale affects the symbol, placement, spacing, and separators, while the currency code identifies the monetary unit. For mixed currencies, show codes such as USD and CAD rather than relying on an ambiguous dollar sign.
There are too many or too few decimals
Review both the currency’s usual fractional digits and any custom display setting. Also distinguish visible decimals from stored precision: a value displayed to two places may retain additional digits for later calculations.
Negative values or zero look unexpected
Choose a supported negative convention—such as a minus sign or parentheses—appropriate to the audience and locale. A dash for zero is only a presentation convention; readers may mistake it for missing or not-applicable data, so use a legend or display an explicit zero when clarity matters. Some systems may show negative zero after rounding; if that is unsuitable, normalize it deliberately before formatting.
Excel displays #####
The column is usually too narrow for the formatted value. Widen the column or double-click its right boundary to resize it to the contents. Microsoft lists column width as the usual cause in its Excel currency-format help.
The format disappears after export
Check the file type and destination. CSV generally carries values, not spreadsheet display formatting; custom formats may also render differently in other spreadsheet programs, PDFs, or accounting systems. Inspect the exported output where it will actually be used.
Quick Recap
Practical checklist
- Keep the numeric amount separate from its currency code.
- Use Currency for individual prices and Accounting when aligned financial columns are the priority.
- Choose a locale-aware formatter for customer-facing software; avoid hard-coded symbols and separators.
- Do not assume every currency uses two decimal places.
- Test positive, negative, zero, blank, large, and fractional values.
- Parse input with the user’s intended locale rather than blindly stripping symbols or replacing commas and periods.
- Check the final exported file in its destination, and document when displayed values are rounded.
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
