The zeros values for the num_digits argument in these formulas tell Excel to return its results using zero decimal places. A positive number specifies the number of digits to the right of the decimal point; a negative number specifies the number of zeros to the left of the decimal. To illustrate: =ROUNDUP(12345.0123,3) = 12345.013

*While its versatility is a plus, when you want to put Excel to a specialized use, you need to apply the correct number format. For accounting, you want to use the default accounting format, which shows numbers in a two-decimal format. You can select a simple accounting format from...*2. Right click the selected cells, and select the Format Cells from the right-clicking menu. 3. In the coming Format Cells dialog box, go to the Number tab, click to highlight the Number in the Category box, and then type a number in the Decimal Places box. For example,... Sep 29, 2012 · I have a query about rounding numbers. I have 8 columns of numbers where the numbers have 4 to 8 decimal places in random order. Now all I want to know is that is there any trick in Excel 2007 to round it to 2 decimal places without using any Formula or Function. I tried to use the decrease decimal button but it is just hiding the decimal places. Jun 22, 2018 · The TEXT function is available in all versions of Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, and lower. Generally, an Excel TEXT formula is used in the following situations: To display numbers in a more readable way or in a format that makes more sense for your users.