|pound sign symbol in excel||1.88||0.3||934||90|
The pound or number signs may also appear if a cell has a formula that generates a negative number. If the column or cell is formatted to display a date and you input a large number, it will also display the pound symbols.How do you show a plus sign in Excel?
2. Then right click and choose Format Cells from the context menu, see screenshot: 3. In the Format Cells dialog box, click Custom under Number tab, then enter +0;-0;0 into the Type text box, see screenshot: 4. Then click OK, and your positive numbers have been added the plus signs at once. See screenshots:How do you insert equal sign in Excel?
You can do as follows to insert equal sign in cells automatically with formula. 1. Select a blank cell (such as B1) for locating the result, enter formula ="="&A1 into the formula bar, and press the Enter key. See screenshot: 2. Keep selecting cell B1, drag the fill handle to the cells you want to add equal signs to.