| Thread | Last Post | Replies |
|
| In a data merge, how do I get 12.5 to transfer as 12.50? | 29 Mar 2008 23:05 GMT | 1 |
I am doing a data merge from excel to publisher and I need the data to transfer over as 12.50 but it will only transfer over as 12.5. I have changed this in format cells but nothing seems to work. Any help would be great!!!!!!!!!!
|
| conversion help | 29 Mar 2008 23:01 GMT | 7 |
Does anyone know of a way to convert *.QIF or *.QFX files (from the bank) to excel? Thanks
 Signature Live simply...Love generously...Care deeply...Speak kindly...Leave the
|
| Cannot Autorecover. Downloaded Autosafe. What now? | 29 Mar 2008 22:54 GMT | 1 |
This has been the umpteenth time that I've lost data because Autorecover cannot be recovered on my machine. The Help menu instructs me to access the recovered file by going to C:\Documents and Settings\my name\Application Data\Microsoft\Excel\.
|
| How to change a pasted web link to hyperlink | 29 Mar 2008 22:33 GMT | 1 |
I have designed a worksheet wherein the cells contains the following information The webpage address link A summary of the page to which the link points
|
| Need to insert a workable document into excel | 29 Mar 2008 22:32 GMT | 3 |
My company has an Excel file we use that has forms on individual tabs. These are standard forms we use with all of our customers that allow us to fill in information on them and print them out without having to constantly open individual documents. We just go tab to tab to tab, ...
|
| VBA Tab question | 29 Mar 2008 22:18 GMT | 3 |
The following code allows me to type a Name in B2 of a new worksheet in two other woekbooks, but not in a new (third) wookbook. Simply put, when a name is typed in B2 the Tab is named the same as B2. Now it does not work in a third Wookbook, new Worksheet
|
| How do i change the default color for selected cells in excel? | 29 Mar 2008 20:09 GMT | 4 |
i have recently changed to Office 2007. Now when I select cells, specifically rows that I want to delete, I click on the row number but the color of the cells doesn't change significantly. It is difficult to see if the cell is actually highlighted. Does anyone know how to change ...
|
| Custom filter date using VB | 29 Mar 2008 20:05 GMT | 1 |
Hi I am running a macro to select rows from data using filter of certain fields. It works fine for the fields where I have to searching for specific text eg
|
| converted spreadsheet to 2007, column letters now numbers?? | 29 Mar 2008 19:57 GMT | 2 |
In a spreadsheet converted to version 2007, the column letters changed to column numbers. The rows and columns are now identified with numbers. I have never seen this in a spreadsheet and am wondering if this can be converted back and why it happened.
|
| How to copying conditional formatting using the fill handle. | 29 Mar 2008 19:45 GMT | 2 |
I'm trying to find a way of copying conditional formatting to adjacent cells similar to using the fill handle when copying formulas from one cell to another.
|
| SMALL/LARGE and text | 29 Mar 2008 18:50 GMT | 4 |
I know SMALL and LARGE don't work on text. Are there alternate functions that could sort text and find the x-th smaller/larger "value" among the cells of the range?
|
| Wrap Text Evenly in Cell | 29 Mar 2008 17:48 GMT | 1 |
I have the following formula: =ROUND(INDEX(Trend,$A7,3),3)*100&"% Avg / "&ROUND(INDEX(Trend),$A7,5), 3)*100&"% Man / "&ROUND(INDEX(Trend),$A7,6),3)*100&"% Net" Which I'd like to wrap after ever "/" in the cell.
|
| Protect sheet but hide rows? | 29 Mar 2008 17:24 GMT | 7 |
I have a large spreadsheet that is used as a tool by many people, the formula in the spreadsheet have to be protected to prevent them being overwritten or deleted by users however I would like the users to be able to hide or unhide rows/columns. When I use the protect worksheet ...
|
| Sorting data from one sheet to another | 29 Mar 2008 17:14 GMT | 1 |
Dear Senior members, i have a data containing on about 10,000 rows which consists the following heads S.No. Name of person, Address, Telephone No. and mobile No. I have to sort out this data on the basis of areas which is divided into 5 catageries on the basis of addresses. ...
|
| If formula---adding another condition | 29 Mar 2008 15:50 GMT | 6 |
I have this formula already set up: =IF(TODAY()<DATE(2008,3,1),"",IF(COUNTIF('Employee Attendance'!12:12,">="&DATE(2008,6,1))-COUNTIF('Employee Attendance'!12:12,">="&DATE(2008,7,1))>0,"No","$25.00"))
|