There are many monetary signs in Excel97 but I haven found one yet for the new euro currency. Any suggestions ?
Excel 2000 (due out later this year) adds support for the Euro. I wish to count the number of cells in a col or row that have a value > 0. How is this done? The zero is displayed in the cells. Count() will only ignore a blank cell. In Excel, you would use something called an array formula. If your range of cells is in A1:A100, you would type the following formula: =SUM(IF(A1:A100>0,1,0)) instead of hitting enter, you would hit Ctrl+Shift+Enter. This keystroke tells Excel it is an array formula. It will evaluate each cell in the range, and if it is greater than 0, add 1 to your result. Otherwise, it will add zero to your result. A second solution in Excel 97 is to use Countif. =COUNTIF(A1:A100,”>0″) I have a list of 3215 product names on a spreadsheet. Each resides in a single cell. I need to put each name in quotes. The names are all in one column. If all of your names are in column A, insert a new, temporary column B. The formula for cell B2 would be: =””””&A2&”””” Yes, there are four
