| Thread | Last Post | Replies |
|
| PERMUTATION AND COMBINATION | 30 Aug 2007 04:14 GMT | 3 |
I know what they mean>>PERMUTATION AND COMBINATION There is a lot of question about it in discussion group but no answer for this simple question ( not even in www.mathworld.com... or other websides). Can someone just offer a simple answer to this problem ?:
|
| Leading zero's missing for SSN numbers... | 30 Aug 2007 03:43 GMT | 3 |
I get a file every month that contains 2500 social security numbers. The dashes are in the right place but some of the leading zero's are always missing in that particular column. Instead of trying to add these manually, is there something I can do instead??
|
| Bring in Word table | 30 Aug 2007 03:19 GMT | 2 |
I am using Office XP and need to bring a Word table into Excel. I have no problem copying and pasting the table, but if a Word cell contains multiple lines, every line in the Excel sheet has it's own cell. Is there a way to tell Excel to keep all text that is in a single Word ...
|
| Change export delimitor? | 30 Aug 2007 03:18 GMT | 16 |
My Excel data contains both commas and tabs so I need to change the export file.csv delimator to "~". How can I do this? (I tried Excel's suggestion to go into the PC's control panel and change the txt list separator to ~ but that didn't work.)
|
| Combine data that spans two rows, preserving cells? | 30 Aug 2007 03:14 GMT | 1 |
I have inherited a spreadsheet containing "records" that are split over two rows. For example: A B C D E F G
|
| How to graph columns from different worksheets | 30 Aug 2007 02:56 GMT | 1 |
I tried to use the hold-CTRL method to select columns on different worksheets and graph them, but it doesn't work. Any ideas?
|
| Sort range must change with added lines | 30 Aug 2007 02:46 GMT | 7 |
Others will be using this workbook so I need to build in the ability to add new names (lines). I have a worksheet called "Names" and one called "Data". The name field (defined as a group) becomes a drop down box on the Data worksheet for easier data entry (one name may have ...
|
| Why does File Size increase with reducing spreadsheet information? | 30 Aug 2007 02:24 GMT | 7 |
I get a spreadsheet about 4.6 MB, and try to delete any useless formula for a table A2:K1000, but I get no idea why the file size for this spreadsheet increases from 4.6MB to 5.6 MB, which does not make any logical sense. Will I create some garbage information when I delete those ...
|
| Linking Questions | 30 Aug 2007 01:56 GMT | 1 |
Hope someone can help me with this.. If you have a Doc A listings names in column A and you want each sheet name in another DOC B to be the names on the list in Doc A. Is that possible with a formula? I know you can highlight all the sheets in DOC B link to one cell in Doc A and ...
|
| Hyperlinking two different pieces of text in a single cell | 30 Aug 2007 01:36 GMT | 1 |
I am creating a curriculum based master calendar in which certain cells will have multiple meeting times by different departments for the same day. I want to be able to link one department (X) to Y document and (Z) department to A document
|
| Sheet protection on MAC | 30 Aug 2007 00:56 GMT | 3 |
When you protect a sheet On the PC Windows platform you are given 15 to 20 seperate Check-boxs for different things that you can Include/exclude.. How is this done on a MAC? When I do the Tools, Protection... ProtectSheet...
|
| IF then statement+ condiditonal format | 30 Aug 2007 00:36 GMT | 4 |
I am trying to color text white (to essentially hide it) if it meets a certain condition. However, it isn't as simple as if the cell =x. My If statement includes recognizing text. =IF(H12="Independent", color text white, color text black). Is there a way that I can use ...
|
| Excel 2002: How is the Excel 2007 file format open in Excel 2002 ? | 29 Aug 2007 23:46 GMT | 2 |
Dear Sir, I understand that there is a download from MS for converting the format for Excel 2007 in order for it to open and edit using Excel 2002. May I know after downloading the format converter, the Excel 2007 file that
|
| Formula help | 29 Aug 2007 23:28 GMT | 2 |
Is there a formula that would help me calculate the following: A B 1 45,000 .50 2 50,000 0
|
| Unprotecting Worksheets | 29 Aug 2007 23:06 GMT | 3 |
I have a file that has multiple worksheets, each are protected (locked) with a similar password for each worksheet. Is there a way to unprotect all worksheets all at once without having to click on each sheet and unprotect it that way? Is there a Macro? Or something?
|