Fresh Excel Tips

Quick and Easy Excel Tips and Tutorials

How to use the DOLLAR function to convert number to currency

In Excel, the DOLLAR function is used to convert a number to text format as well as add a currency symbol. The DOLLAR Function’s syntax also allows us to set how many decimal places to round the currency. Here is the syntax that is used for the DOLLAR Function. DOLLAR(number, decimals) number: This refers to a number, [...]

How to Use the ROUND function to round numbers in Excel

Today, we will be learning to use the the Excel built-in ROUND function to round a number to a specified number of digits. The syntax for this function is: ROUND(number, num_digits) number: The number to be rounded. num_digits: The number of digits that the specified number will be rounded to. If greater than 0, number is rounded [...]