Select the cell(s) in question
Goto the menu FormatCellsNumber tab

Select Number and set Decimal places to 2
OK out

Type 100 in the cell and it will now display as 100.00
Type 100.1 in the cell and it will now display as 100.10
Type 100.235 in the cell and it will display as 100.24

Note that when you FORMAT the *display* of a cell the cells TRUE underlying
value is what you actually typed in. So, 100.24 is *displayed* but the TRUE
value of the cell is 100.235. This is where people get messed up when
downstream calculations don't seem to add up.


--
Biff
Microsoft Excel MVP


"frustrated acountant" <frustrated
wrote in message ...
WHEN I ENTER A NUM SUCH AS 100.00 IT SHOWS UP AS 100. OR 100.10 AS 100.1
HOW
DO YOU FORMAT TO GET EXCEL TO LEAVE THE ZERO,S AFTER THE DECIMAL?