Protect Currency Text For Free

Overview FormulaDescription=TEXT(1234.567,"$#,##0.00")Currency with a thousands separator and 2 decimals, like $1,234.57. Note that Excel rounds the value to 2 decimal places.=TEXT(TODAY(),"MM/DD/YY")Today's date in MM/DD/YY format, like 03/14/12=TEXT(TODAY(),"DDDD")Today's day of the week, like Monday8 more rows

All you need to do is follow these steps: Position the insertion point in the table cell where the number will reside. Press Ctrl+F9 to insert a pair of field braces. Type the equal sign, followed by the number (65.78). Type a space, followed by \# and another space. ... Enter the format specification, in quote marks.

Tip: To quickly apply the Currency format, select the cell or range of cells that you want to format, and then press Ctrl+Shift+$. Like the Currency format, the Accounting format is used for monetary values. But, this format aligns the currency symbols and decimal points of numbers in a column.

To write an amount in dollars, first write the country symbol (US) followed by the dollar sign ( ) and then the dollar figure. For example, US 25.99. American bills or paper currency comes in seven denominations: 1, 2, 5, 10, 20, 50, and 100.

Write amounts using the relevant currency symbol followed by numerals. Don't put a space between the currency symbol and the numerals.

The USD (United States dollar) is the official currency of the United States of America. The United States dollar, or U.S. dollar, is made up of 100 cents. It is represented by the symbol $ or US$ to differentiate it from other dollar-based currencies.

To format a text field as currency Right-click Cost and select Format. The Format Objects dialog box opens. On the Number tab, select Currency from the Category list. The default settings use a dollar sign and two decimal places.