⟩ I am converting from Quatro Pro to Excel. What happened to my cell comments?
Excel comments are indicated by a small red dot in the upper right corner of the cell. Float your mouse pointer over the dot and the comment pops up.
Question and Answer:
Home MS Excel
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
When I enter a value, it appears with two decimal places. For example, when I enter 154 it shows up as 1.54. Whats wrong?
I am trying to open files called "Excel 97 Templates" with my Excel for Windows 95, Version 7.0. I get the message "(filename).xls file format is not valid". What gives? Is the "Excel 97" saved file just unreadable by my version?
My question is when your working with multiple worksheets how do you transfer added figures from one worksheet to another without losing the total?
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?
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?
There are many monetary signs in Excel97 but I have not found one yet for the new euro currency. Any suggestions?
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?
