| Thread | Last Post | Replies |
|
| Currency Format When Merging into Word | 08 Mar 2007 11:44 GMT | 1 |
I have a database file set up in Excel 2003 and my columns are formatted as currency with the $ symbol. However, when I merge my data into my Word mail merge file the $ symbol will not show up and the number isn't displayed with decimal points. For example: $90.00 would show up ...
|
| Average | 07 Mar 2007 20:25 GMT | 7 |
Hi...how do I average a column of percentages, one for each month if the month has yet to pass. There is a formula in each of these cells (doing something else)and its causing excel to return "#DIV/0" error because I want to average all 12 months but only 2 of the months have ...
|
| Excel and Word too after reinstall opens and closes down right awa | 07 Mar 2007 05:25 GMT | 1 |
I just had to rebuild system I have windows XP pro and installed office 2000 and Excel and Word are both opening up and closing down right away. I have tried repair, reinstalling after uninstall and nothing works.
|
| troubleshoot long text wrapping in Excel cell | 06 Mar 2007 20:30 GMT | 2 |
Hi! Does anyone know why Excel fails to wrap text within a cell if the text is quite long (I suspect this happens when text exceeds the obligatory @#$@%! 255 characters per cell), i.e., it starts out wrapping it and then just hides
|
| SUM not updating automatically | 05 Mar 2007 21:06 GMT | 3 |
Hi! I am using Excel 2003. I have a document with lists of numbers that are totalled with =SUM at the bottom, such as =SUM (E4:E14) . I frequently change the numbers in the lists throughout the day and the totals automatically update based on my changes. I have been using this ...
|
| Excel crashers on opening a workbook | 02 Mar 2007 13:48 GMT | 1 |
I have a workbook that I keep in the XLStart directory so that it opens on Excel 2000 starting up. Last nite I had made a couple of changes to it, and Excel crashes when I open that workbook. Any ideas about how to fix it? This has a lot of lines of macro code that I wouldn't ...
|
| Chi Test Function | 02 Mar 2007 11:48 GMT | 1 |
I am taking a statistics class and I need to use the Chi-Test Function Key. One of the questions I completed with no problem. When I went to another question, I keep getting an error message something like 3.35146E-09. I'm not sure what the E-09 stands for. Unfortunately this ...
|
| Formlua won't calculate | 02 Mar 2007 01:33 GMT | 1 |
I currently have the following formula =IF(D12="SWR","Liz b",IF(D12="TCH","lex G",IF(D12="POS","Mav H",IF(D12="INT","Rich H", IF(D12="FOU","Ton T",))))) but when i click out of the box, it does not work out the value, the text
|
| Excel Auto-Fit of Rows and Columns | 01 Mar 2007 03:30 GMT | 1 |
I am using auto-fit for the heights of the columns but for some reason it does cover up parts of the content. Also for the width some sentences do cross the right border. I tried to put the spreadsheet into a new document and also tried to copy
|