| Thread | Last Post | Replies |
|
| can I retrieve an xl file that was saved as opposed to save as | 17 Mar 2008 21:37 GMT | 2 |
I stupidly saved over an existing IMPORTANT file as opposed to using the "save as" function. Is there any way to retrieve the original file that was saved over?
|
| Difference between date & time calculation | 17 Mar 2008 21:03 GMT | 6 |
Is there a way to calculate the difference between two dates only counting working days, but also including the difference in times? I am familiar with the NetWorkDays formula, however, I need to find the difference between the specific times. Ex. We are trying to calculate the ...
|
| Removing "read only" | 17 Mar 2008 20:10 GMT | 3 |
For some reason I can't remove the "read only" from one of my Excel folders. I go into the Properties and remove the check in "read only" but when I go back, the "read only" box is still checked. Am I doing something wrong? The folder has to be accessible to a team of people ...
|
| How to make cell contents blink? | 17 Mar 2008 19:54 GMT | 1 |
reaching a milestone, would like to color a cell and have it blink / flash.
|
| Text to columns | 17 Mar 2008 19:27 GMT | 11 |
Hi, Daily we open a .lst file, which is a text file, which used to put each line of data in to the first cell in a row. We then used the Text to Columns feature to split in to individual cells. Within the last week, when we open the file it splits in to individual cells ...
|
| style button | 17 Mar 2008 19:26 GMT | 3 |
I need a button installed on my standard toolbar, which will have behind it a custom format/style (just as comma/percent/dollar do). Any help?
 Signature Boris
|
| Excel - Parse Name | 17 Mar 2008 18:49 GMT | 6 |
I have to parse out names that are not consistent. The data comes in as: Mary Smith John J Smith I want the out to be: Smith John J or Smith Mary. Can anyone help?
|
| Excel Number Conversions | 17 Mar 2008 18:34 GMT | 2 |
I have a problem when using numbers in excel. I've created a record called UPC for my item references and number are supposed to be viewed as this: 659078740069. I save the format in csv. and when I go to reopen to file the numbers that I've entered show as 6.59079E+11. I've ...
|
| Different Margins for 2nd page? | 17 Mar 2008 18:13 GMT | 1 |
I've got my letterhead set up in the first page header. Don't need the letterhead for the second page of the document... How do I change the top margin for just one page? Example - I need 2 inches for the header on the 1st page, but I don't need that much for page 2 and
|
| Sum by date | 17 Mar 2008 18:08 GMT | 6 |
In column B, I am trying to add up the values in columns E, H, K, etc (every third column), but ONLY if the corresponding date in columns C (for E), F (for H), I (for K), etc (every third column) is within 6 months from TODAY. I can move the data around if the values need to be ...
|
| time stamp question | 17 Mar 2008 17:43 GMT | 2 |
Ok i figured out how to do a time stamp, but know i am trying to format the rule that JE McGimpsey provides in his website. So that the date stamp does not appear in next cell but in another cell. Below is a link with the example of the rule.
|
| Headers & Footers in Excel | 17 Mar 2008 17:35 GMT | 1 |
I have an excel document with about 15 worksheets for which I want the same headers & footers on each. Can I repeat them without have to set up individually?
|
| Passwords | 17 Mar 2008 17:21 GMT | 2 |
Hi ... Would anyone know if an employee password protected a spreadsheet in Excel and then was 'let go', is there a way to 'crack' the password to get into the file?
|
| Worksheet Function | 17 Mar 2008 17:18 GMT | 1 |
Is there a worksheet function which will look into the contents of a cell, find a value and return it? Here is an example of what I am looking for: Cell Return
|
| Formula > 0 | 17 Mar 2008 16:45 GMT | 3 |
I'm having trouble coming up with the right formula. If the range C8:C13 is >0, then return a 1 in the cell, otherwise return 0 in the cell.
|