Live Chat Software by Kayako |
Knowledgebase: Microsoft Excel
Setting The Decimal Place In An Excel Worksheet.
Posted by - NA - on 01 April 2006 05:43 AM
|
|
Solution: Excel defaults to its 'General' number format. So, if you enter 1.00 into a cell, Excel displays it as 1. If you need to set a range of cells to a fixed decimal format, select the range and choose Format/Cells. When the Format Cells dialog box opens, click the Number tab and select Number from the 'Category' list. Use the 'Decimal places' spin box to set the number of places you want to use and then click OK to accept the setting and close the dialog box. | |
|
Comments (0)