| Thread | Last Post | Replies |
|
| Excel Won't Recognize Numbers - Can't delete space before data | 25 May 2005 00:07 GMT | 5 |
I can't get Excel to recognize numbers when copying text from a specific site for some reason. When I copy and paste numbers and search terms after doing a query from this site... http://inventory.overture.com/d/searchinventory/suggestion/
|
| simple petty cash ledger | 25 May 2005 00:07 GMT | 7 |
My employer wants me to account for $300.00 I receive at the start of the school year. He gave me a printed sheet with the following columns: Date Description Deductions Additions Balance.
|
| Relative file paths | 24 May 2005 23:26 GMT | 7 |
I have an excel spreadsheet that contains calculations and a Word document that has a number of link references to it within the text of a report. Everything works fine and the excel sheets show up in the report as another page with headers and footers and correct page numbers etc.
|
| How to stop Personal.xls opening at startup | 24 May 2005 23:24 GMT | 6 |
Somehow I've got this file starting automatically when I open Excel 2003. How can I make it stop? And what does it do? I hope I don't need it. Thanks,
|
| Cell formatting when hyperlinking | 24 May 2005 23:18 GMT | 1 |
I do not want the cell format to change when I add a hyperlink. Presently, the font, colour and underscore changes whenever I add a hyperlink. As I shall be adding links over a period of time, I do not wish to keep changing the formatting all the time. Is there a way of avoiding ...
|
| Invalid Picture Error | 24 May 2005 22:41 GMT | 4 |
I'm trying to install a plug in that will compare and highlight any differences between two excel spreadsheets. I have it working on 3 machines w/ Office 2003 but then on the other 2 machines I can't get it to work becasue I get:
|
| Ghost links in Workbook | 24 May 2005 21:29 GMT | 2 |
Often times I work with workbooks e-mailed to me. Many of these workbook contain links to the creator's local files, which are annoying when opening the workbook. I have erased all the range names that are not used in the workbook, I have looked for the cell with reference i.e. ...
|
| Adding summaries, rows and pre-population | 24 May 2005 20:52 GMT | 1 |
I have a worksheet where the user can click a button marked 'Create Activity'. This spawns an Activity worksheet with the naming convention 'Activity (n)'. The user can click this as many times as they like, but must click it at least once.
|
| Formula Help (to many expresions) | 24 May 2005 20:33 GMT | 8 |
Could one of you give me a hand with this... I'm trying to put a formula in a spreadsheet that has too many expressions in it. I understand there is a limit to the number of equations that can be in a formula but there must be a way around the
|
| Sintax Help! | 24 May 2005 20:29 GMT | 4 |
I would like to print a sheet and a graph from a macro. I would like to call both by the Number and not the Name of each. In other words if the sheet was named Chart10 (BoxTops)I need to be able to call the sheet by "Chart10" not "boxtops". This way if the name changes the
|
| arrange data by criteria | 24 May 2005 19:57 GMT | 4 |
My new responsibility at work is to align (sequence) the values from column C to match column A while using column B as the set criteria (key?). For example, the value from b2-c2 - 14 would move down two rows to be in alignment with A4. To continue, the value from b3-c3 - 45 ...
|
| Excel file automatically entering string in cell for each row | 24 May 2005 18:15 GMT | 2 |
I have a really simple Excel file that is being used for a Credit Card Log. The user enters data for each purchase order, the data that is kept is, PONum PODate
|
| Excel Date Time to Unix Time | 24 May 2005 18:04 GMT | 2 |
I have a field in Excel which is formatted as 4/21/2005 10:43 I am uploading this feild into mysql I need the datetime to be converted to unix time like 1116910800 any ideas?
|
| unable to type in selected row | 24 May 2005 15:20 GMT | 1 |
1. I just finished typing row 110, on row 111 I start typing and it bounces back to 110. What should I do? 2. How do you command columns or rows to repeat info.
|
| Another User Form Query | 24 May 2005 14:38 GMT | 2 |
Using Excel and the following formula =DATEDIF(I3,TODAY(),"y") in the User Form Text Box it shows 105 if I haven't entered a date in cell I3 is there anything I can add to the above formula that will show a zero or just leave the Text Box blank until a date is entered in cell I3.
|