| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell format doesn't take place
I have a formula that subtracts one cell from another. For example:
$10,000 - $4,000 = $6,000. However, in the cell with the answer ($6,000), it displays as 6000. I tried changing the cell formatting, but no matter what I do, the "sample" doesn't change. It insists on 6000. If I remove the formula, and put in $6,000 manually, it will display as $6,000. Am I missing something? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically place text in one cell into cell in another sheet | New Users to Excel | |||
| format cell to place colon btw every 2 alphanumeric characters | Excel Worksheet Functions | |||
| How to place a value in another cell | Excel Discussion (Misc queries) | |||
| using a UDF in place of a cond. format, b/c I need 4, not three | Excel Discussion (Misc queries) | |||
| how can i place the Format Painter icon on the Context menu? | Excel Discussion (Misc queries) | |||
Threaded Mode
