Group:  Microsoft Excel » microsoft.public.excel.newusers

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Threads Replies Last Post
125 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>  
Javascript Question
Hey everyone, I have a question regarding Excel that I can't seem to locate an answer for. I copied and pasted a bunch of information from ESPN onto an Excel Spreadsheet. I wanted to categorize the date but everytime I click on the cell I am directed to a webpage due to a javascript. How do you remove the javascript? If anyone can help I'd appreciate it! John -- jmkratt -----------------...
2 22.08.2006 08:02:29
how can I reobtain microsoft excel?
For some reason microsoft excel is no longer on my computer!! I have no clue why but it is gone for what ever reason, I never got rid of it, but how can I find it or get it back?...
4 22.08.2006 06:20:32
Where to find Hotfix 829348?
Been going in circles thru Microsoft KB articles. Finally found the hotfix that will address this problem: • If you lock cells in an Excel 2002 workbook by using a Microsoft Visual Basic for Applications (VBA) macro, and then save and close the workbook, you can click to select a locked cell after you reopen the workbook. I've been living with this slightly ...
5 22.08.2006 02:27:30
Sort Data Base By Column
I'd like to sort a data base by column C and have all the associated date in the rest of the columns sort as well. How is that done? Thanks for any help Travelersway -- travelersway ------------------------------------------------------------------------ travelersway's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=17623 View this thread: http://www.excelforum.com/show...
5 21.08.2006 22:22:55
separating data into multiple columns
I have a spreadsheet that lists people in the format LastName, FirstName. I want to create a formula that will put the last name in one column and the first in a different column. Can someone please point me in the right direction? Any help would be greatly appreciated. Asa Reynolds -- AsaReynolds ------------------------------------------------------------------------ AsaReynolds's Prof...
2 21.08.2006 22:07:35
WHAT ARE PARENTHESIS IN FORMULAS?
I have a formula: =(h24*j24)+(h25*j25)/sum(h24:25) But I have no idea how many parentheses I am suppose to place around the formula or what additional ones I need other than the one that surround the indivudual formula. ...
3 21.08.2006 21:43:17
Home Key - Excel 2003
In Excel 2003 is it possible to go to the beginning of a spreadsheet by pressing just the Home key instead of Ctrl + Home. I'm sure that I used to be able to do this in an earlier version. Thanks -- darkcity1965 ------------------------------------------------------------------------ darkcity1965's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15712 View this thread: h...
3 21.08.2006 21:28:23
deleting cells
I have one cell that is deleting itself when I open the invoice. I retype the name in, save it, then close the program. When I go to reopen that invoice it breifly shows the typed name and then it disapears....
2 21.08.2006 15:59:02
CANNOT START THE SOURCE APPLICATION FOR THIS OBJECT
I get above error message when i tried to embed a PDF document in Excel. Can someone help. ...
1 21.08.2006 15:55:03
Help Using COUNT or SUM/IF???
I want to be able to return a count where the cell in columns J and M are both "X". Example: Colums J through M are cars andColumns N through O are the repairs. I want to be able to count by car, how many times for each repair. So I would need a total number of occurences where columns J and N are both equal to "X" I hope this makes sense....
2 21.08.2006 14:25:27
Dates
Hi, Can any one of you please help me to get rid of the default excel dates to standard format dates....
3 21.08.2006 10:53:01
how to add hours and show actual hours not decimal numbers
I am trying to put together an employee work schedule, showing actual hours for punch in and out times. How do I set it up to add actual hours not decimal hours. Example: 11 hours is 0.46, if I change it to military time it will show 11 hours for the day but the total for the week is still all of the decimals added up. This is probably simple to do but I am too new with this. Any hel...
3 21.08.2006 07:35:37
Excel and launching userforms
Greetings, I want to do something that I hope is not too unusual. i want to test a value in a cell, and if it one thing or another... launch a user form. Here is the scenario... test cell a1, if it is greater than 10, then launch userform1, userform1 will ask a question, if yes is selected it will write some text "and" the contents of cell a1 to cell b1. How do you do this? Thank...
7 21.08.2006 00:39:45
Copying Cells with Drop Down Lists
This is a multi-part message in MIME format. ------=_NextPart_000_0021_01C6C496.879E8810 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable good Evening Fellow Excel Users I have a spreadsheet below which i created one Darts - League 2006-2007=20 Week 1 MATCH No 1=20 =20 Team A V Team B=20 =20 ...
3 20.08.2006 23:17:39
Help! I can't get a spreadsheet to open
Have tried EVERYTHING - it keeps saying that I don't have access - AND I was the one who created it - any suggestions? ...
2 20.08.2006 21:02:38
Format Paste Special - is there a way to do this ?
With Copy/Paste you have Paste Special to control the actual paste ie just Values,Format etc Is there a similar method for Format Painter, ie just Paste background = colour or just borders I'd love to be able easily to just copy the background colour from one = cell to another. I know I could write macro to do it, but you'd need one for each Format= = feature you wanted to cop...
3 20.08.2006 18:51:49
if statement
I have the following formula: if(date-TODAY()<=7,"Payment due","") The problem is when today's date falls after the first date the result is a negative number and it returns "payment due" since it's less than 7 even though the payment has been made. A solution (since I'm a new user, not likely to be the best one) might be specifying a range of from 1-7 days but I don't know how t...
3 20.08.2006 17:52:01
i share my copmuter. how can i setup seperate new user account
hello. i want to setup a new outlook user account but i share my copmuter with another users...
3 20.08.2006 16:54:06
Multiple pages open when I open Excel
I was working away in Excel and thought I had clicked the Save icon on the standard toolbar. At that point the block of figures I had been working on became highlighted (I wasn't using any formulae) I then closed the Excel programme and tried to open it again and this time multiple pages opened each was a copy and each highlighted in the same way! Can ayone explain what I did wrong? I just want t...
2 20.08.2006 16:52:52
chngeing english numbers to arabic numbers
dear supervirsor i would like to know how to change english numbers to arabic number on excel , where when i change the language from english to arabic the numbers didnt changed it still in english ...
2 20.08.2006 15:13:06
referencing a list on seprat tab, then calculate
HI! fellows, on first tab I have columns that is the days ( of a projected week) of a construction project.the rows are my employees. this project was 18 days long and 18 total employees.each day had different number of workers on site with each worker having different rates . the other tab has the employees rates adjacent to thier names in a list. Question is: ( i may need macro but ...
3 20.08.2006 10:43:01
Highlight the entire row or particular cell using conditional formatting
I want highlight the entire row or particular cell. I have columns called permit no., description, requester, date requested validity, approved and permit opened. . I want highlight the entire row or particular cell if the permit is not opened 7 days from the date of approval. Is it also possible to highlight with flashing text. A sample excel file is attached Thanks +---------------------...
2 20.08.2006 10:05:53
Help, I cannot Save!
I created a document and locked the worksheet to protect the formulars, before creating a template for the document. But now when I open the document and insert a new sheet using the template I created, the document will refuse to save. Once I click on save, office assistant will say "doc not saved". What could I have done wrong? PLease help. computerfineman -- computerfineman ----------...
3 20.08.2006 08:48:03
how to automatically update inventory list with sales
Please provide the help on how to update the inventory list when some items are sold. ...
3 20.08.2006 06:37:01
How access "address an envelope" through Tools ?
Attempting to use Office Word 2003 to address sigle envelopes. Instructions state use Tools to locate "Address an Envelope" however cannot access this format. What am I doing wrong? All suggestions would be appreciated....
3 20.08.2006 06:20:01
125 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>  

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net