How do I set up my document to include zeros when I type in a dec.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am typing in for example 564.00 and it takes away my decimal and leaves 564.
 
Highlight the cells you want to format. Right click and select "format
cells", select number tab, select number and set the number of decimal places
you want.

Robert
 
I think you need to format the cells.

FORMAT --> CELLS then choose "Number" or "Currency" or "Accounting" and you
can specify how many decimals you want to display.

REMEMBER if you enter 10.555 but display only 2 decimals, Excel will show
10.56 but the actual value of the cell will be 10.555. (can cause confusion
when adding a column of numbers.

Hope this helps
 
hi,
goto Tools>options>edit tab.
make sure the fixed decimal box is checked. set places to
2. this will apply to all workbooks.
Regards
Frank
 
Frank

This is not the correct usage of fixed decimals.

That would return 5.64 which OP does not want.

Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting Data Lists 2
How do I get excel to leave a zero in front of a number? 3
How to retain decimal zeroes? 5
How to subtract a number from a Mergefield? 0
Trailing Zeros 3
Number of days in a quarter between two date ranges 3
Excel 2007 adding a column of negative and positive number 2
How do you hide .00's in a worksheet & keep the ones that say 10.7 3

Back
Top