why won't my cells format correctly?
 

I have a formula set up in a column of cells to subtract one cell from
another. The cell that displays the results will not format to two decimal
places. I have tried everything in the format cells menu, but I am not sure
if it is because there is a formula or what is going on

why won't my cells format correctly?
 

Format Cells Number tab Number Decimal places: 2

"shannonc80" wrote:

I have a formula set up in a column of cells to subtract one cell from
another. The cell that displays the results will not format to two decimal
places. I have tried everything in the format cells menu, but I am not sure
if it is because there is a formula or what is going on

why won't my cells format correctly?
 

I have tried that already and it is still not working

"Teethless mama" wrote:

Format Cells Number tab Number Decimal places: 2

"shannonc80" wrote:

I have a formula set up in a column of cells to subtract one cell from
another. The cell that displays the results will not format to two decimal
places. I have tried everything in the format cells menu, but I am not sure
if it is because there is a formula or what is going on

why won't my cells format correctly?
 

What is the formula and what result are you getting? It shouldn't be a
problem to format as you want to,
Regards,
Alan.
"shannonc80" wrote in message
...
I have a formula set up in a column of cells to subtract one cell from
another. The cell that displays the results will not format to two decimal
places. I have tried everything in the format cells menu, but I am not
sure
if it is because there is a formula or what is going on

why won't my cells format correctly?
 

I'm guessing that your formula is returning a text value rather than a
number? The text value 1234 and the number 1234 may look identical, but
Excel treats them differently.

What is your formula? Perhaps enclosing your formula within the VALUE()
function would help? This would convert the text to a number.

HTH,
Elkar


"shannonc80" wrote:

I have a formula set up in a column of cells to subtract one cell from
another. The cell that displays the results will not format to two decimal
places. I have tried everything in the format cells menu, but I am not sure
if it is because there is a formula or what is going on

why won't my cells format correctly?
 

I figured it out! i had the wrong formula set up for subtracting

"Teethless mama" wrote:

Format Cells Number tab Number Decimal places: 2

"shannonc80" wrote:

I have a formula set up in a column of cells to subtract one cell from
another. The cell that displays the results will not format to two decimal
places. I have tried everything in the format cells menu, but I am not sure
if it is because there is a formula or what is going on