⟩ There are many monetary signs in Excel97 but I have not found one yet for the new euro currency. Any suggestions?
Excel 2000 (due out later this year) adds support for the Euro.
Excel 2000 (due out later this year) adds support for the Euro.
I am trying to get the percentage of two cells by dividing one cell into the other. Some of the time both cells might have a Zero in each. Therefore the DIV?
I am new at this Excel game. How do you figure elapsed time? I have formatted the cells in military time, create a start time column and an end time column and would like to know the difference?
I want to count the number of cells in a range that have a particular interior color. The countif function seems like the right kind of answer but how to I return the color of the interior for each cell in a range? I would like to do something like =countif(b1b10, cell("interior","Red"))?
Thanks for your great answer, but this results in my data be backwards; i.e. rather than 12345 I need it to be 54321. Any further thoughts?
I download data which comes to me in a column. I want to use it in a complex sheet that needs data in a row. How can I convert the column data into row data?
How can I enter the symbol for the new Euro currency in my spreadsheet?
I want to add 25 to all of the cells in column A. I do not want a new column, I want to add it right to the cells in column A?
I use a large spreadsheet on a daily basis with 31 worksheets (one for each day of the month). Each worksheet is huge.I would like to insert another sheet in the workbook and insert a button to copy another worksheet to the end of the workbook and then rename the sheet to the correspondingday of the month?
Somehow, my worksheet has external links to files that are no longer around. How can I delete the links?
Where can I find some really good information on how excel treats year 2000 dates? I need simple (and that is what u guys provide)?