| Thread | Last Post | Replies |
|
| Number format code | 14 Feb 2008 13:36 GMT | 11 |
I can't seem to figure this one 21 1/2" vs. 21 " I am trying to create a custom format number code showing the inch hash marks after the number. My problem is when a whole number is input the space
|
| Creating a list of cell values | 14 Feb 2008 09:32 GMT | 3 |
I have three cells: A1 with the value of 1 A2 with the value of 2 A3 with the value of 3.
|
| Always view column titles | 14 Feb 2008 01:58 GMT | 3 |
I knew how to do this in Office 2003, but I can't figure out / find how to have the column titles always visible as I add new data. Can anyone help me??
|
| Running the same VBA code for Many Sheets | 14 Feb 2008 01:15 GMT | 2 |
I have a lot of sheets in my workbook and I need to run the same code in each sheet, but one variable of my VBA code is exactly the name of the sheet. I have a sheet with the name of all sheets that I will use:
|
| apostrophes | 14 Feb 2008 01:05 GMT | 21 |
I have a formula with an apostrophe, but it's not a leading apostrophe. ='results.csv!$B1 I wrote it this way for reasons I won't bore you with, but there is a good reason. The idea is that a particular moment I can take out the apostrophe
|
| How can I color every other row | 14 Feb 2008 00:05 GMT | 6 |
Help please. I want to make it easier to use a large spreadsheet where two rows are used for each record. Filling in the background color of every second row prevents mistakes when entering data. I want to color only the
|
| zeroes being truncated | 14 Feb 2008 00:03 GMT | 3 |
Hi, I have a tab delimited file that has products that I import into design software and I am having a problem opening it in excel because the product codes sometimes lead with zeroes. How can I open the file without getting rid of the zeroes? I can open the file with notepad and ...
|
| numbers not correct | 13 Feb 2008 23:11 GMT | 1 |
When I try to add numbers to a cell, they are converted to a date. How can I correct this? I have the "general" numbers tab selected. (Excel 2007)
|
| numbers in cells | 13 Feb 2008 22:58 GMT | 1 |
everytime I enter a number in a cell it gets converted to a date. How do I correct this? I clicked on the "numbers" tab and selected "general", but that wasn't the soulution.
|
| Display duplicate records? | 13 Feb 2008 22:12 GMT | 5 |
I have a list of over 13000 of my customer names. Many of the customers have the same name, but are at a different address. I need to identify those with a duplicate name. I don't want to delete them, I just want to highlight or otherwise identify them. Any ideas?
|
| Printers Missing | 13 Feb 2008 19:36 GMT | 1 |
I'm having a very odd problem. I have two printers shared off of a workstation using Vista Ultimate. Another workstation running Vista Home Premium, has those two printers mapped and can successfully print test pages to them. They show up under Printers in the control panel
|
| Conditional formatting based off cell with text? (i.e. "less than 80%") | 13 Feb 2008 18:56 GMT | 2 |
Is Excel 2007 smart enough to do this? I have an instance where I need conditional formatting set up for a cell whose condition is based off of another cell.
|
| excell worksheet | 13 Feb 2008 18:44 GMT | 3 |
I need to coordinate information from one excell worksheet into another one. How do I make that happen?
|
| To Stan Brown From Robert11 Re Copy & Past Problem | 13 Feb 2008 18:36 GMT | 1 |
Just a quick thanks for the help; appreciate it. Problem was with the other program, not Excel. Regards, and thanks, Bob
|
| Setting an Icon Set conditional format for a single cell??? | 13 Feb 2008 17:12 GMT | 1 |
This is my first question here and I'm pretty new to Excel, but I have a question about the Icon Set conditional formatting. From what I understand it's intended for use of a range of cells.
|