Change Case And Round Figure Formula of MS Excel

Change Case And Round Figure Formula

In Excel, you can change the case of text using the UPPER, LOWER, or PROPER functions. The UPPER function changes all the characters in a text string to uppercase, the LOWER function changes all the characters in a text string to lowercase, and the PROPER function capitalizes the first letter of each word in a text string.

For example, to change the contents of cell A1 to uppercase, you can use the following formula:

scss
=UPPER(A1)

To round a number in Excel, you can use the ROUND function. The basic syntax for the ROUND function is:

scss
=ROUND(number, num_digits)

number is the number you want to round and num_digits is the number of digits you want to round to. For example, to round the value in cell A1 to 2 decimal places, you can use the following formula:

scss
=ROUND(A1, 2)