Microsoft Excel questions?

Question

1. How would I make it so that my formulas only show numbers greater than zero?

2. How do I include a symbol like a) or $ in front of a number and not have it effect formulas?

Answer 1

1.On the Tools menu, click Options, and then click the View tab.
To display zero values as blank cells, clear the check box.

(This will show negative numbers.)

Alternative cheat:
On the Format menu, click Conditional Formatting.
In the box on the left, click Cell Value Is.
In the second box from the left, click less than or equal to.
In the box on the right, type 0.
Click Format, and then click the Font tab.
In the Color box, select white.


2. Format: Cells...
Number tab select currency.

Answer 2

A- To only show values other than zero do this: Go to "Tools" then "Options" and under the "View" tab uncheck "Zero Values" or do conditional formatting of the cells with an operator such as "Greater Than". Note that the first way would display values LESS than zero, it only eliminates the "zeros" so if you don't want to show for example a value of -2 then use the conditional formatting.
B- Format the cells as "Currency".

Answer 3

1) Use an IF command e.g. IF(blahblahblah>0, ""). The "" puts in a blank rather than the negative result.
2) For the dollar sign, simply click on Currency Style. You can't have a close paren without messing up your formula. I can't understand why you'd want it. If you want to display it as text, precede the contents of the cell with a single quote (').
-MM

Answer 4

Format
Cells
Number
Custom
over-type 'General' at the Type prompt with
[=0]"";[>0]"$$"00.000;[red]
when a zero value is entered, it will not be displayed ""
semi-colon
when a value greater than zero is entered, it will be prefixed by "$$" or whatever you put in quotes, and it will have at least two digits before the decimal point and exactly three after it 00.000
semi-colon
any other numeric value (must be less than zero) will be red (with general formatting applied.
It may be easier to copy
[=0]"";[>0]"$$"00.000;[red]
and paste it using control V

Enjoy.

Answer 5

1.Let your formula A1. Change A1 for IF(A1>0;A1;"")
You will get positive number or empty cell in case of negative number.
2.Apply text format to the cell. Type anything.

Answer 6

such as your cursor contained in the cellular, correct-click and choose format Cells. click on Alignment tab and mid-way down by technique of textual content administration, click on Wrap textual content, then click on okay to close communicate container. something you type in that cellular will wrap like you indicated above. you are able to spotlight particularly some cells in a row or column and word an same formatting. Or, in basic terms follow Cliff's suggestion above

Answer 7

I think you might be talking about conditional formating?

In excel Format-> conditional formating
If cell value->is greater then-> 0


For the auto dollar sign. Format-> cells and change it to currency.