| Thread | Last Post | Replies |
|
| excel 2007 - sorting | 05 Aug 2006 23:21 GMT | 2 |
I am having real problems with excel 2007. I am exporting csv files from a database - when I import them in to excel I want to sort by the keyfield (numeric) but it is just not working at all, has anyone else come across this ?
|
| cubic | 05 Aug 2006 22:33 GMT | 14 |
I am new to this thing of cubic. How the cubic feature works in excel? I am asking this because I saw a program on tv but i didn't see it from the begining and it was saying something about formulas and how to work cubic sq
|
| HELP. Im a newbie. | 05 Aug 2006 21:37 GMT | 2 |
i know that this is probably really easy but im a newbie. i searched all over the forums for this. anyways. i have a drop down menu and i have a cell on the screen that displays whatever the drop down menu says. now the drop down menu has initials
|
| Adding Character Question | 05 Aug 2006 20:15 GMT | 2 |
This is my first post on this forum. Thanks for having me. I have a se of data consisting of tracking numbers and locations. For example: A1 B1 54321568 California
|
| Drop Down List | 05 Aug 2006 19:31 GMT | 2 |
I'm having some trouble regarding 'same entries' selection... I.E. I have the following data List of Hospitals Machine Used Machine Readings Hospital A Roche Analyzer 12.65
|
| How to create a date mask and drop down list? | 05 Aug 2006 18:28 GMT | 6 |
I am not sure if this is the proper wording, but is their anyway t create a standard date function/mark, to type dates in without havin to type DASH, having to type out the entire year etc.... Also how can I create a drop downlist to choose from (that show
|
| Office 97 Re-Install | 05 Aug 2006 18:17 GMT | 2 |
Have a legimate cd for office 97. It is an upgrade version but I don't have the underlying (older version) software that the installer program is looking for. Is there any way to "fake out" the installer program?
|
| my excel files are being opened in Word and are unreadable Why? | 05 Aug 2006 17:49 GMT | 2 |
Files are being saved in the correct format and can be opened normally from the recent files section of the File Menu in excel. The copmputer tried to open them in Word from My Computer
|
| Adding payroll stubs payroll calculator | 05 Aug 2006 17:37 GMT | 2 |
I am trying to add more payroll stubs on my payroll calculator. I have 5 employees and it only gives me stubs for four of them. I need to be able to add more with out having to set it up myself, as I don't know how.
|
| How to calculate pass/fail percentages entered on a spreadsheet? | 05 Aug 2006 17:29 GMT | 2 |
I am trying to set up a spreadsheet with driving test results including one column to say pass one to say fail and calculate the percentage of each on a monthly basis. I can enter the info but don't know how to calculate the percentages
|
| SQL with Excel | 05 Aug 2006 17:12 GMT | 2 |
Is it possible to get a result set from data stored in an excel file with SQL statement? e.g. Select Sheet1.Column_A, Sheet2.Column_B from Sheet1, Sheet2 where
|
| Hiding a cell from printing... | 05 Aug 2006 16:57 GMT | 3 |
I want to hide a specific cell when I print. Not an entire row nor a column - just one specific cell. I don't want to change the font to white, nor hide it (either row or column) Ive searched the Net to no avail. Can somebody help me?
|
| Is it possible to find multiple data? | 05 Aug 2006 16:39 GMT | 5 |
We have a small lotterysyndicate in work which is all logged onto an excel spreadsheet. Is it possible to search all numbers and all occurances at once, rather than individually? Ie - we have 15 lines of 6 numbers each - can i search for all 6
|
| PivotCach.CommandText Modification | 05 Aug 2006 15:55 GMT | 2 |
Our company had 200 + excel reports that we automatically refresh the pivot tables each day and email them out. When we do a server migration or copy for a new program we go into each pivot table and add the new view from the new database. I have successfully changed the command ...
|
| Cell Text in File Name | 05 Aug 2006 15:18 GMT | 2 |
Does anyone know of a way to generate a Save As <file name> from the text in a cell? This would be really useful for all sorts of things. Jeff
|