Published On: Sat, Jun 23rd, 2012

How to Deal With Currency Values in Excel 2010

Microsoft Excel 2010 comes up with an option to deal with various currency values. You can apply DOLLAR function, so you can easily place decimal and round off different values according to your own choice.

Here you will learn about:

How to deal with currency values in Excel 2010 using the DOLLAR function.

1) You need to launch Excel 2010 and then open a spreadsheet in which you wish to convert your data into the currency values. In below screen shot, we have taken some sample data in the Excel 2010 worksheet.

2) Now we need to convert values mentioned in the Price column into currency values. Therefore, you need to select the field and navigate to the home tab, from the number group. Then you need to select Currency from drop-down button.

3) When you click on the currency button, the whole data in the selected field will be converted into the by default currency values. You can find the same in the below screen shot.

4)Therefore, if you need to modify the default currency values into some other country’s currency, you need to click on the button right at the bottom of number group as shown in the below image.

5) You will then reach at the format cells dialog box. Hence, from the symbol option you can select your desired currency symbol. However, you can change the decimal positioning from the decimal places. In order to continue, you need to click the OK button. The below screen shot is showing the same.

6) The values in the selected field will be converted into the desired currency, as shown in below screen shot.

7) You have the option to amend the decimal places from the Format dialog box, as mentioned above. However, in order to have full control over the same, there is another option available. Here we will use the DOLLAR function for the purpose of handling currency values with decimal places. The main purpose of DOLLAR function is that it converts text values in the cell to number when it calculates. The full syntax of DOLLAR function:-=DOLLAR (number, [decimals])

In the above syntax, the very first argument is the number, location, or value of the cell. Whereas, the next argument represents number of decimals you need to place in the value. You can write the formula as: – =DOLLAR (C2, -2)

Therefore, below screen shot showing that C2 is the location of the cell and two will show rounded off value of currency. In the price column we have entered number values as a text, but by using DOLLAR function, excel 2010 calculates them as a number.

8) Apply the formula to the whole field by simply dragging the plus sign at the end of the cell towards the end of the column. Below screen shot suggesting the same.

You can notice that in the rounded off values, the decimal values can be omitted and two rounded-off two digit placed from the right side.

Share

About the Author

Leave a comment

XHTML: You can use these html tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

close