Open the Format Cells dialog by pressing Ctrl 1 or right click the cell s and choose Format Cells. For example if you wanted to round the value of A1 to 2 decimal places your formula would so far look like this. ROUND can be used for.
The formula used is shown below.
To round down to the nearest specified place use the ROUNDDOWN function. Enter the number you want to round followed by a comma. Copy the formula using Ctrl D taking the first cell till the last cell needed formula. For example if cell A1 contains 237825 and you want to round that value to two decimal places you can use the following formula.