| Thread | Last Post | Replies |
|
| Time | 22 May 2008 16:32 GMT | 9 |
I am creating a time sheet. I need to convert a time format (7:30) to a decimal format (7.50). How do I do this?
|
| VLOOKUP please help | 22 May 2008 16:24 GMT | 2 |
I have got two sheets with names platform and participant check In platform (colomns), I had specified the details for the training participants like Name, Surname, date of training, venue, etc.... It could be above 700
|
| cell parameters? | 22 May 2008 16:14 GMT | 4 |
I have a simple spreadsheet for people to fill in for information like supplier name, etc. My problem is, everyone should be putting supplier name in the exact same way - same spelling spacing, etc...but it's not happening. Is it possible to
|
| Excel keeps auto-changing my formulas to include other cells. | 22 May 2008 16:12 GMT | 2 |
Excel keeps auto-changing my formulas to include other nearby cells. How can I create and save a formula in a spreadsheet without the program changing my formula? Each day I have to correct the formula because Excel automatically changes it. I don't kow how to stop this from ...
|
| Excel changes HDA to HAD | 22 May 2008 15:52 GMT | 3 |
When I am in a spreadsheet, I have tried typing in HDA into a cell. When I hit enter, it is automatically changed to HAD. I've even tried changing the spell check to ignore words in capital letters, but it still changes. I've also tried putting the ' before it, still changes. ...
|
| Can't get NETWORKDAYS to calc elapsed banking days in a month | 22 May 2008 15:44 GMT | 2 |
I want to calculate the number of banking days in a month, and so NETWORKDAYS and its "holiday" argument is the relevant formula in Excel 2007. For each date, I can use EOMONTH(date,-1) to get the start of the month date. Try 1 Jan 2008 without any "Holiday" argument - the result ...
|
| Date formats English/US | 22 May 2008 15:24 GMT | 2 |
I have some experience of using Excel (2003), but cannot do anything other than very simple VBA. I have a piece of equipment (a blood glucose monitor), which, being of US origin, displays dates as "05.22", when it means "22nd May". It displays times as "01:15 pm".
|
| Drop Down Lists | 22 May 2008 15:24 GMT | 2 |
Is it possible to create a drop down list that shows the sheets in a workbook?
|
| custom data validation | 22 May 2008 14:26 GMT | 3 |
I did post a similar question yesterday but it may have been too confusing and I did not get an answer to suit my needs. I have decided to simplify my question: I have 3 columns (A, B and C), I need to add data validation to ensure dates
|
| Can i set up an overdue pop up in excel? | 22 May 2008 14:22 GMT | 3 |
Can you set up Excel to popup when something is overdue a certain date?
|
| Data Label size | 22 May 2008 12:24 GMT | 4 |
I am trying to position datalabels on a scatter chart using Bob Bovey's XY labeller. This puts a label on a chart for each point. Many of the labels are sloping upwards and consequently I need the bottom left of the label next to the point concerned. The label position is defined ...
|
| Change value of cell automatically if entered the wrong number | 22 May 2008 10:45 GMT | 7 |
I (sometimes) have a row with numbers from 1 to 5... What I want is: when I enter value = 3, and that value (3) already exists in the column, it has to correct that automatically into 4, with or without a warning.
|
| Does the COUNTIF criteria parameter accepts functions? | 22 May 2008 09:50 GMT | 3 |
I'm trying to use a function (WEEKNUM) as the criteria for a range in COUNTIF. Is this possible?
|
| countif colored numbers | 22 May 2008 09:12 GMT | 2 |
I am looking to count a certain colored numbers in a column. Example: All the Blue numbers, then all the Red numbers. I looked over "Color Functions In Excel" and that didn't really seem to help. I tried =COUNTCOLOR and it had a #NAME type error.
|
| Error Codes | 22 May 2008 09:08 GMT | 1 |
How can i hide / unhide error codes in a excel sheet?
 Signature - Banura
|