Pages

Sunday, October 30, 2011

Use the DOLLAR function to convert numbers to currency in text format - Text Functions - Microsoft Excel Tutorials


Use the DOLLAR function to convert numbers to currency in text format in Microsoft Excel

The DOLLAR function of Microsoft Excel converts a number to text format and applies a currency symbol. The currency format will be rounded to the specified decimal place.

 DOLLAR(number, decimals)

number: A number, a reference to a cell that contains a number, or a formula that calculates a value. decimals: The number of digits to the right of the decimal point.

If negative, number is rounded to the left of the decimal point.
If omitted, Excel sets it to 2.

To convert numbers to currency:
1. In cells A2:A10, type numeric values.
2. Select cells B2:B10 and type the following formula: =DOLLAR(A2,2).
3. Press <-Ctrl+Enter->.


Watch the Video Tutorial - https://www.youtube.com/watch?v=dN41pqxD0Wk

 

No comments:

Post a Comment

Submit Site to Google Free Articles Search Engine Submission - AddMe Directories Suggest Link Business Directory AutoBackLinks Directory Bingo Bahia Submission Software Reviews