decimals & show totals

F

Frani

I cannot seem to get the decimal to show with zero
example: 500.00 comes out 500 I have tried the format
cell and the format column; also my answer for a sum
continues to show the formula only in the cell.
What am I not doing?? I am on xp with a downloaded office
excel program. HELP!!
 
K

Ken Wright

Sounds like your cells are formatted as text. Format the cell as number or comma, then put in
your formula (Not the other way round).
 

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

Cumulative formula for word table 0
Show a cell's formula in text format in a linked cell 2
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Decimal point in general format 1
Change number from multiple decimals to 2 3
Using text and formatting sum function in formula 3
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Remote stopped working in PowerPoint Presenter View 0

Top