| Thread | Last Post | Replies |
|
| keeping format | 16 Mar 2005 18:03 GMT | 3 |
I have an excel spreadsheet with 3 digit numbers and some lead with zeros. I went into format cell and created my own format so that I get the zeros no matter how many there is. My format is just a simple simple custom 000. Now after I get these numbers in this format I need
|
| Unexpected quote marks in exports to tab-delimited files | 16 Mar 2005 17:56 GMT | 4 |
I am experiencing a problem exporting data to a tab-delimited file. The results of the export cause unexpected (and unwanted) double quotes to appear (apparently) randomly throughout the file. They appear in certain cells - it is replicable, and it's always the same cells - but ...
|
| expandable areas | 16 Mar 2005 17:31 GMT | 1 |
In Excel can I hide a certain number of rows but make them expandable, like the menu system that is used on the left here? I keep track of tasks and they are separated into weeks. Each week may have 30 rows and I would like to collapse them into a single row and be able to ...
|
| linking workbooks | 16 Mar 2005 16:23 GMT | 4 |
how can i link a cellA in workbookA to a cellB in workbookB? Whereby when cellA is updated, cellB will get the same value as well. thanks
|
| Help with Payroll Formulat Needed | 16 Mar 2005 15:24 GMT | 3 |
I'm trying to create a spreadsheet that tracks vacation pay and sick pay for the HR department. The problem I am running into is one of formula syntax. For sick time we start accruing from the date of hire, but an employee doesn't
|
| PERSONAL.XLS is gone after upgrade to WinXP | 16 Mar 2005 15:13 GMT | 4 |
After being upgraded to Windows XP Pro, my PERSONAL.XLS is gone. I have searched my entire HD (including hidden and system files), but it is gone. This was a Win2K Pro PC prior to the upgrade, and using Office 2003 Pro. This is a 2-fold query:
|
| One worksheet for three separate hair stylists appointments. e.g.. | 16 Mar 2005 13:35 GMT | 1 |
My daughter-in-law, who purchased this Microsoft Officw software, is the owner of a hair salon, and employs three hair stylists. At her request I have been asked to make a system where she can use a computer to enter her three stylists appointments on. As there are three ...
|
| Sort Solution needed | 16 Mar 2005 12:37 GMT | 2 |
I have a worksheet with 5 columns and 5 rows. A number gets entered into each cell (A1:E5). I need to sort so that each number is placed in sequential order (smallest to largest) across the columns and down the rows (see example below). Can this be done?
|
| Excel hyperlinks: | 16 Mar 2005 05:09 GMT | 10 |
I have a small database in Excel with hyperlinks to .jpg files. In Excel 97, the link would open the .jpg with the program associated with the .jpg extension. In Excel 2002, the file is displayed with Microsoft Photo Editor. How can I change the association in Excel?
|
| is there someway to select what i have "found"? | 16 Mar 2005 04:28 GMT | 1 |
is there a way to select multiple cells based on the text contained within them? i can use "find" to find what i am looking for, but i can not seem to select all of these cells. i have taken a crash course in naming, formulas, go to..,
|
| Save as Template | 16 Mar 2005 02:39 GMT | 9 |
I saved template as XLT hoping that whenever saved it would prompt me for a save as file name. However that was not the case when I entered data in the template and saved it. It saved it under the original XLT file name without asking for the save as name.
|
| Excel sheet display | 16 Mar 2005 02:26 GMT | 1 |
I have an excel workbook (Excel 2003), but only one sheet of it is displayed since today. The same happens if I open the CD where the workbook is saved as a copy, but then another sheet is displayed. Can anybody help, please?? Thanks in advance,
|
| number changes into date-but I do not want it | 16 Mar 2005 01:40 GMT | 2 |
when I type in the pH value of let's say 11.2 it changes into date like nov.02. I do not want them to happen. what is wrong?help!!!!!!!!!!!!!!!!!!!!
|
| Date Formula changes | 16 Mar 2005 01:11 GMT | 8 |
I created a excel spread sheet which I emailed to someone at another location and after they received it a cell which had the date format changed to a custom format. I have run across similar problems before with the same issue, can anyone tell me why this happens and how can I ...
|
| Removing blank rows | 16 Mar 2005 01:07 GMT | 1 |
I have a spreadsheet that pulls data from an outside source and performs certain changes to the data through a macro I run. Once the macro is finished, there are anywhere from 3,000 to 20,000 rows of data and the rest of the rows (up to 65,000 plus) are blank. Normally, when ...
|