Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cells with wrapped text won't auto-adjust row height correctly | Excel Discussion (Misc queries) | |||
Losing Original Cell Format when pasting in cells | Excel Discussion (Misc queries) | |||
Why will my cells not format? | New Users to Excel | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
format cells having text | Excel Discussion (Misc queries) |