Setting the number of decimal places, in the number format, to 2.
FORMAT / Format Cells / Number tab / Number / 'Decimal places' window / fill in '2'.
If the number is accurate to two decimal places then you write it exactly as in the question.
It then is 3.69 when rounded to two decimal places
The product will have at most 2 decimal places.
Setting the number of decimal places, in the number format, to 2.
Two decimal places.
It is simply: 2000.00
There is a button entitled "increase decimal". Its location depends on the version of Excel you are using.First you must select the cell/s you wish to alter and then press the "increase decimal" button.In Excel 2003 it is on the Formatting toolbar. It has the appearance of a small blue arrow, pointing left and is followed by a decimal point and single zero, overlying a decimal point and a double zero and looks roughly like the following:← .0.00In Excel 2007 the button can be found in the following location: On the Home tab, in the Number group.Please see related links.
Yes, but you can then change the amount of decimal places you see.
accounting number
FORMAT / Format Cells / Number tab / Number / 'Decimal places' window / fill in '2'.
For a single cell: with the cell selected, Format menu > Cells > Number tab > Category: Number [By default the Decimal places is set to 2] > OK.To apply this format to a whole column: position the mouse icon over the column heading (such as B); the icon becomes a black arrow pointing down. Click to select the column, then use the Format menu as above.To apply this format to a range of cells: select the range, then use the Format menu as above.You can also adjust the horizontal position of figures within a cell: select the cell(s), then Format menu > Cells > Alignment tab > explore the options under Horizontal, especially Right (Indent) with Indent set at 1 or 2.When one cell has just the right format, you can apply its format to one or more other cells using the Format Painter. Select the "perfect" cell, then click the paintbrush icon in the Formatting toolbar, then click another cell to apply the format without changing the value in the cell. If you double-click the Format Painter, you can go on "painting" cells as long as you like. To exit, press Esc on your keyboard or click the Painter icon again.
If the number is accurate to two decimal places then you write it exactly as in the question.
zero values displayed as hyphens
The answer probably is no, because I do not believe there is any kind of Excel format called "control number." It sounds like you are asking about the number accounting format.
Press Ctrl-F1 to open the Format Cells dialog box. The Number tab should be open. Click on Currency on the left and in the right set it to 2 decimal places and then click OK.