Hi,

Sorry, in the previous procedure, the step 3 is wrong. Please follow the
changed procedu

You do this way too. It is much easier control the value in the cell.

Do the following:

1. Click a cell in the worksheet.
€¢ On the Format menu, click the Cell command or Press Ctrl 1. The Format
Cells dialog box is displayed.
€¢ Click the Number tab.
€¢ In the Category list, by default the General is selected.
2. Enter a value. For example 100
€¢ On the Format menu, click the Cell command or Press Ctrl 1. The Format
Cells dialog box is displayed.
€¢ Click the Number tab.
€¢ In the Category list, the Number is selected with two decimal.
3. On the Formatting toolbar, click the increase Decimal to a decimal to the
number.
4. On the Standard toolbar, Double-click the Format Painter icon.
5. Highlight the number of cells you want to select to type the new values.
6. Press the Esc key, to reset the mouse pointer to arrow pointer

Note: In the Standard toolbar, use the "increase decimal" or "decrease
decimal" to add or reduce the decimal points to a numeric value.

Challa Prabhu

"frustrated acountant" wrote:

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?