| Thread | Last Post | Replies |
|
| Count characters | 18 Jul 2007 20:10 GMT | 4 |
Does anyone know of a formula or function that will look at a cell and tell you how many characters there are in a cell? Thanks in advance!
|
| Dates showing as serial number | 18 Jul 2007 17:40 GMT | 3 |
I have an excel sheet that has all the dates showing as serial numbers. For example... 8/24/2007 shows as 39318 and 6/27/2007 shows as 39260. I have tried changing the format of the cells but it stays as the number and change to the date. Help please.
|
| transpose skip zeros(0's) | 18 Jul 2007 17:23 GMT | 2 |
I am trying to transpose a row into column. I want the column to take only non-zero and non-blank values,e.g., 1 blank 2 0 blank 3 4 after transpose
|
| Convert number with comma to number with dot | 18 Jul 2007 17:08 GMT | 2 |
Is there an easy way to convert "1.12" to a number, if your system is set to use the comma as a decimal separator? The value() function does not appear to take a format or locale as argument.
|
| Find/Found | 18 Jul 2007 15:10 GMT | 1 |
Can not get Found to respond. Object: Get PersonName in Sheet2, Go to Sheet1, Find PersonName. If Found put PersonName & address into Sheet2 Else put PersonName in Sheet3. Sheet2 has no address. Sheet1 has most, but not all names that are in Sheet2
|
| Why #NA when using VLOOKUP? | 18 Jul 2007 15:09 GMT | 8 |
I'm trying to use VLOOKUP to find lowest value in a small group. The exact sample is below: A B 1 3.0001 A 2 2.9442 B
|
| Update name range | 18 Jul 2007 14:40 GMT | 2 |
I have about 50 Excel files in a folder call "Import Updates". Within all of the Excel files I have a sheet call "Table" The user will populate the columns A - E each month. The number of rows varies, within the Excel sheet, there is a name range call "DataImport". The user ...
|
| Validation | 18 Jul 2007 14:24 GMT | 1 |
How can I create a vba code to make a validation in a excel's cell? This validation must be the datas from a field in one table in ms access. Thanks,
|
| strings | 18 Jul 2007 14:09 GMT | 1 |
In, Id like to write a macro to look at a cell to see if it contains a particular word. eg if i had " Id like to write a macro to look at a cell " in a1, and i want to see if the sentance contains "macro". How would I go about this. I know how to move through the cells just
|
| Add new line in a cell | 18 Jul 2007 12:00 GMT | 2 |
I must be suffering from oldtimerers disease but I can't remember how to to add a new line inside a cell. I have tried various combinations of alt, shift, ctrl, enter but I can't get it.
|
| SQL instruction | 18 Jul 2007 08:51 GMT | 1 |
I don't known nothing about SQL - it's my big problem in excel! Now I'm trying to import some datas from ms acess whith some criterias, but I don't know how to create a SQL instruction. I did a form in excel with two textbox: txtgm and txtdate - the user
|
| Excel 2007 sorting bug? | 18 Jul 2007 08:17 GMT | 6 |
If an Excel 2007 sheet (#1) has formula referenced cells to another sheet (#2), and if the column in sheet (#2) containing the referenced cells is then A-Z sorted on the value then the original references in sheet #1 get lost as they are now pointing to different cells.
|
| in excel useing comments how do you add clip art to comments? | 18 Jul 2007 08:14 GMT | 2 |
in excel useing comments how do you add clip art to comments?
|
| How do I create a timetable I can update easily | 18 Jul 2007 08:12 GMT | 2 |
I need a timetable I can call up on my computer and adjust easily as classes change
|
| Numbering worksheets using Auto Fill | 18 Jul 2007 07:44 GMT | 2 |
Is it possible to number worksheets using Auto Fill Method? Your assistance will be appreciated.
|