| Thread | Last Post | Replies |
|
| howto convert a number into words like 10 to ten | 01 Sep 2006 00:43 GMT | 4 |
i want to print numbers entered as numbers in words like 1 is one,20 as twenty also to have two decimal places
|
| IF cell is currency, not text, and over this much? | 31 Aug 2006 23:54 GMT | 5 |
I am trying to sort out a list using a helper column. The column I am trying to sort out has monetary amounts with cells formatted as currency. At odd places in the column, though, are headers in cells formatted as text. I put an IF formula in my helper column to give me "Yes" ...
|
| Value Labels on Pivot Table Chart? | 31 Aug 2006 23:04 GMT | 1 |
Hi. I have a pivot table chart. I want to have its data labels show the value of each bar, e.g., if the bar is up at 26, I'd like the number "26" to show up on the bar. I can do this once by right clicking the chart's series, selecting
|
| Moving Average - How can I make the function? | 31 Aug 2006 21:25 GMT | 3 |
I need to construct a function to calculate (not simply calculate it!!) the moving average for the following data Day Data Moving average (5 days) 01-gen-06 5
|
| Strange Date Format Bug | 31 Aug 2006 21:21 GMT | 3 |
I don't know which subtopic this belongs to. Each time I work with dates in Excel 2003 on my machine, the date, regardless of the format, becomes a number. For e.g. When I type the date 1/1/2006, the Formula Bar shows me,
|
| Column Labels | 31 Aug 2006 19:18 GMT | 3 |
New to excel. How do I "name" or "label" columns, instead of A, B, C...? A quick step-by-step is much appreciated. Thanks in advance, Fran
|
| Hide empty rows in Excel worksheets | 31 Aug 2006 19:18 GMT | 5 |
I'm working on a program that enabled the user to insert 10 information and print them. I developed the forms using VBE. I have specified all the information into their own cells in Excel worksheets.
|
| dropdown list to a page in worksheet | 31 Aug 2006 18:44 GMT | 13 |
I have a list of names in worksheet1 I have a Page for each name in Worksheet2 I need to creat a dropdown list in worksheet2 of names in worksheet1 which will allow me to jump to his specific page.
|
| printing forms | 31 Aug 2006 17:40 GMT | 6 |
Hi, i have this table in one sheet Name Surname Adress Tel.No. E-mail Gender Paul Gaultier Baker st 9995 paul@g.com M John Smith Rose st. 5556 john@smith.com F
|
| Trouble with condition nested formula | 31 Aug 2006 17:26 GMT | 2 |
I am trying to nest two formulas based on the result of another cell: the formula must do one of two functions based result on the lookup cell. A12: is either "A" or "I" B1 $100,000
|
| Function or Formula to Add lowest X number of values in a range | 31 Aug 2006 16:40 GMT | 5 |
I'm looking for a way to total (SUM) the lowest X number of values in a given range of values. For example, I have a row of 15 values. I'd like to do some analysis and determine what the total and average is for the lowest 5 values, lowest 10 values, or whatever number of ...
|
| IF with date criteria | 31 Aug 2006 13:16 GMT | 4 |
This is my problem: Column C has text values (Phone, Meeting) Column F has dates (01/01/2006 - 08/31/2006) but, Column F also has misc text ("*", ".", "?" or can be blank)
|
| Simple Chart Question? | 31 Aug 2006 13:09 GMT | 1 |
You folks seem to be able to do almost anything with excel, so this is probably childsplay to you. But not to me. I want to create monthly weather charts with Rain as bars, but Humidity, Min Temp and Max Temp as lines.
|
| Combo Box in control Toolbox | 31 Aug 2006 12:23 GMT | 1 |
i have multiple combo boxes in one sheet. where can i set the tab order so i can navigate using the tab key? need your help asap
|
| Find Missing Records | 31 Aug 2006 11:46 GMT | 3 |
I searched enough on this topic but couldn't find anything that i could put to use. Hence this query to you all. I have two excel sheets. Both Sheets have two columns (Name, Email Address)
|