| Thread | Last Post | Replies |
|
| relation between cell and picture which is above it. | 11 Aug 2007 13:24 GMT | 1 |
in my sheet there is one column called 'picture', and many picture are in cells belongs to this column. my problem is that, i know picture is just floating on the sheet, it doesn't belong to any cell. But, i need get the picture which is above certain cell.
|
| Conditional formatting: If text or If date? | 11 Aug 2007 12:54 GMT | 7 |
I have a spreadsheet that tracks reports. In a far right-hand column, I have a cell for when a re-write is submitted. I put an "X" in the cell when a re-write is needed, and the date submitted when it's turned in.
|
| Named sheet to change Cells names | 11 Aug 2007 04:46 GMT | 3 |
Situation is really tricky for me, (D;E) 4 in one peace, and i need it to be named as my sheet but not fully, Sheet name is T 060_esik (and "esik" part needs transport into cell D;E4) is it possible? I guess i explained correctly! Thnx
|
| Percent of time | 11 Aug 2007 04:22 GMT | 1 |
Hi I would like to know how to get percent of time? i.e. 30% of 12:00 or 70 of 11:00 and still able to sum up / add-up the total results automatically? Thanks!
|
| How do I convert text to a date? | 10 Aug 2007 23:15 GMT | 3 |
I have received a spreadsheet with a range of cells holding date information, but in text format as follows: '20070801' - i.e. the format is ''yyyymmdd' Is there an easy way to convert these cells from text to a date
|
| Database | 10 Aug 2007 22:57 GMT | 2 |
Folks I have a small excel spreadsheet which I use for data entry at the end of each day. Rather than discard the previous day's data, I want to append this data to a
|
| Printing Form to Include All Options in Excel | 10 Aug 2007 19:49 GMT | 1 |
I am extremely new to creating forms in Excel so bare with me here! Is there a way that I can print my form so that all options in my list box appear? I have a list box that is extremely long, so on the electronic version I want to have a scroll bar to save space. However, when I ...
|
| export XLS to CSV with particular delimiter | 10 Aug 2007 19:38 GMT | 5 |
I would like to know how can i export content of XLS file to CSV specifying the delimiter will not be "," (comma) but ";"(semicolon) ? thanks a lot, Al.
|
| exporting data to access | 10 Aug 2007 18:34 GMT | 1 |
I'm trying to export data from excel to access, but I'm having some difficult: The layout of my sheet is the following: A B C D
|
| Sorting - Excel 2007 | 10 Aug 2007 18:26 GMT | 3 |
I use Excel 2007 quite often for lists and other functions that require sorting. When I set up specific sort orders in a spreadsheet those "orders" do not stay with the spreadsheet when I save the file. In previous versions of Excel when I set up a sort order for a spreadsheet
|
| i cant even type in a cell | 10 Aug 2007 17:42 GMT | 3 |
can anyone help me on how to use this trial version? i cant even type inside a cell
|
| Excel search function | 10 Aug 2007 17:19 GMT | 2 |
Is there a way to use the search function to search non "0" value in cell. Ex - if i have "110254" in cell A1 - I need the position of non zero digit in the string of A1.
|
| Control Source Property | 10 Aug 2007 17:17 GMT | 2 |
Hi Group, I'm using the control source property in VBA to link a form text box to a worksheet cell. Although this works I have found that the worksheet cell is overwritten by the form textbox (even if not updated
|
| What is the best way to Query a flat file | 10 Aug 2007 17:13 GMT | 2 |
I have a flat data file. Name status Jones started Johnson started
|
| Blue screen | 10 Aug 2007 16:56 GMT | 4 |
Wheni start exel i get a blue sheet no ribbon just nothing any body any idea's thx Amraam
|