| Thread | Last Post | Replies |
|
| setting an assumption | 02 Nov 2006 22:21 GMT | 1 |
What is an assumption and how do i set an assumption? I'm taking an excel course in school and i just wanted some clearafication on assumptions. Thank you in advance for any help.
|
| excel as database | 02 Nov 2006 22:16 GMT | 2 |
I need to transfer info from word (table format in columns) to excel ultimately to be used in access (once purchased/installed). In the meantime 3 questions. 1. how to I transfer info from a column (in excel) to a row?
|
| Get values from another sheet (was: Load certain values with opening a file) | 02 Nov 2006 21:59 GMT | 1 |
In another post I asked for a way to get standard values in a spreadsheet everytime the sheet is opened. I got a good answer, but i want to do more: This is the trick that does it for now:
|
| 2 questions | 02 Nov 2006 21:58 GMT | 2 |
how do i get a total for a list of names entered in ie alan billy chris dave ...... also is it possible for the date to be automatically enterd in each sheet tia
|
| Index sheet based on print pages | 02 Nov 2006 21:55 GMT | 1 |
Hello NG I have a wokbook with several sheets. One of these is the final output that I use for presentations and printing. It is organized as a number of pages where each page is a summary of key financials for a brand, all the pages
|
| Compound interest calculated daily | 02 Nov 2006 21:44 GMT | 1 |
I would like to create a worksheet that will calculate the daily interest of a compound interest account between two specified dates that I enter. For example
|
| resetting horizontal header margins | 02 Nov 2006 21:44 GMT | 4 |
Is there a way to reset the header margins so that they go further to the left edge of a print out? You can adjust them vertically, but there doesn't seem to be a way to adjust them horizontally. Thanks!
|
| Don't want to tile sheet background | 02 Nov 2006 21:16 GMT | 1 |
I have an image for the background of a worksheet. I don't want it to tile. Is there something I can choose in Excel to keep the background from tiling...or... is my only alternative to edit the image to the same size as the portion of the worksheet I'm using?
|
| Global currency conversion | 02 Nov 2006 20:51 GMT | 1 |
I have a complex spreadsheet, about four linked worksheets all in US dollars. I have been asked to produce the same thing in pounds sterling. Is there any way that I can divide the value of all cells by say 1.9 to give me the sterling value - I have created a new cell with
|
| Combine cells and insert date. | 02 Nov 2006 20:49 GMT | 1 |
I have a formula in which i am combining text from various cells. =CONCATENATE(G3,G4,G8,G9,G10,G11,G12) In this case, one cell (G9) contains the date formula =TODAY(). What I am getting from G9 is 39023. What I need is the actual value
|
| Multiple hyperlinks in one cell | 02 Nov 2006 20:36 GMT | 6 |
Is it possible to have multiple hyperlinks in one cell (referencing say 5 different cells)?
|
| Cheap Printers | 02 Nov 2006 18:57 GMT | 4 |
Also ran across a Lexmark printer on eBay for $1 which I saw in Walmart for $59 but don't know if the quality is good. Here is the link: http://offer.ebay.com/ws/eBayISAPI.dll?ViewBids&item=290035543618&ssPageName=STR K:MESE:BIDN Anyone familiar with the quality of this item?
|
| How add minutes to a date | 02 Nov 2006 17:59 GMT | 3 |
I've got in a cell a time in this format 04/03/2006 14:34 and I want to add the value of a cell that respresents minutes tot that one cell. So if the cell contains 22, i want to add 22 minutes to the first cell that returns 04/03/2006 14:56
|
| i need help with conditional formating with dates | 02 Nov 2006 17:14 GMT | 2 |
I'm trying to link daily schedules to fill in automatically from information entered into a weekly schedule. I have two conditional formatting questions> 1.if a time is left blank on the weekly schedule and I need it to remain blank on the daily I need to ... right now it ...
|
| whichever Mondays has in a certain month? | 02 Nov 2006 16:12 GMT | 3 |
Hello, my english is bad, but i try... whichever Mondays has in a certain month? example: November 2006 = 4 Mondays use Excel 2003
|