| Thread | Last Post | Replies |
|
| My text RUSINGA keeps changing to Rising. Why? | 21 Aug 2007 16:12 GMT | 4 |
I create a new worksheet. When I enter my data, the formulae calculates correctly. However, when I enter the word RUSINGA, my worksheet changes the word to Rising. I do not know why. I did not create conditional formatting for that to happen.
|
| How do I manipulate data pulled from within an excel calendar? | 21 Aug 2007 15:46 GMT | 1 |
I would like to be able to pull user entered numerical data from within a calendar in excel and manipulate it outside of the calendar. Any ideas?
|
| Applying a cell format within a Formula | 21 Aug 2007 15:46 GMT | 2 |
Does anyone know how to apply a format within a formula? such that the result can determine the cell format?
|
| Help - cannot compare values properly even though they display same thing! | 21 Aug 2007 15:34 GMT | 2 |
I have a simple IF statement that compares the values of two cells: =IF(D5=G5,"Good","Bad"). Simple enough. The problem is that even when the value of the cell is exactly the same i.e both D5 and G5 show "WT_STEDY", it is still returning "Bad". I did a little bit of error
|
| Comments - print at end of sheet | 21 Aug 2007 15:28 GMT | 2 |
I've chosen to print some very small comments in my worksheet at the "end of the sheet" by using the Page Setup options. The problem is that is does not print the comment "at the end of the sheet"; it prints it on a separate page. Is there anyway to cause the comment to print ...
|
| Field Names | 21 Aug 2007 15:25 GMT | 1 |
 Signature Bob Levin
|
| Hyperlinking | 21 Aug 2007 15:12 GMT | 1 |
Does anybody know if theres an easier way to hyperlinking different files in the same worksheet, instead of going back and forth to edit the file name in the hyperlink?
|
| Return a "yes" or "no" in vlookup | 21 Aug 2007 14:54 GMT | 5 |
Please, what is the proper vlookup syntax to get a yes or no answer in a vlookup formula, instead of a column return? thanks.
|
| Grid lines won't print | 21 Aug 2007 14:52 GMT | 3 |
Even though I check the box "Print grid lines" they don't print. They don't show in Print preview either. Thanks for any help on this.
 Signature Bob Levin
|
| Cells may look "empty" when quickly scrolling up or down | 21 Aug 2007 14:22 GMT | 2 |
Does anyone know why cells may look empty, without actually having lost their contents, when scrolling up or down quickly? They will not refresh correctly until they are moved of and then on the visible window again, of course after having stopped the fast scrolling.
|
| Pivot Table Link Error | 21 Aug 2007 14:18 GMT | 2 |
I have a spreadsheet that I've linked to another spreadsheet's pivottable. So it has a formula with GETPIVOTDATA. I can send this others, but as soon as they save it their desktop or anywhere else. The Pivottable is lost and goes to Zero, like the data isn't there. Does anyone ...
|
| Excel sheet validation | 21 Aug 2007 14:00 GMT | 1 |
My qn is completely based on excel sheet.It contains fields like country,state,city.From a table iam retreiving the values of country which is given in the country table in SQL server 2005 and displaying it in a ddl. The state table is linked with country table using a ...
|
| automatically advance to next cell | 21 Aug 2007 13:36 GMT | 4 |
Is there a way to limit a cell to only one character then automatically advance to the next cell after a single character is entered.
|
| If formula | 21 Aug 2007 13:26 GMT | 5 |
I’m trying to update a formula for our employee bonus system, but I’m afraid I’ve got in a bit of a muddle. We currently have =IF(x<60,0,(2.5*(x-60)))
|
| My Cell drops the Zero if it is first. | 21 Aug 2007 13:26 GMT | 1 |
I my excel spreadsheet I have a column for zip codes/postal codes. And since > I collect both US and European addresses, I formatted the cell for "General". But when I have a zip code that the first number is zero, I lose the zero
|