ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel (https://www.excelbanter.com/excel-discussion-misc-queries/19591-excel.html)

stickybun

Excel
 
How do I get the the last two zeros to appear in cell i.e 10.00

Duke Carey

With the cell selected, press Ctrl-1 or choose Format | Cells from the menu

In the left panel of the 'Number" tab on the dialog box that's presented,
choose 'Number' and then, in the rihgt panel, select the # of decimals you
want displayed.


"stickybun" wrote:

How do I get the the last two zeros to appear in cell i.e 10.00



All times are GMT +1. The time now is 08:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com