Summary: I have two different date where I want to know the no. of days, weeks, months and year. Is there any formula in Excel 2000 which can help me to solve ...
Summary: I have an invoice created in Excel 2000 that automatically fills in today's date when I create the invoice. However, everytime I open that invoice at ...
Summary: Hi, Please help me in comparing dates in Excel. Let the cells have dates as given below... A2 = 10-Jan-2009 B2 = 20-Feb-2009 C2 = 30-Mar-2009....
Summary: Actually, for your string you would need to use: =MID(A1,5,2)&"/"&RIGHT(A1,2)&"/"&(LEFT(A1,4)) With your string in A1, click on the cell where you wan...
Summary: When entering an AlphaNumeric in COL A, I would like to check contents of all previous cells in COL A for IDENTICAL entry, and warn or prevent continu...
Summary: I am preparing a costing sheet in excel 2000 where I must show an amount both in number and word i.e. 2,500/- (two thousand and five hundred and 00 on...
Summary: Hi, Can anyone help me with Excel 2000? Can I have a file such that whenever I open it, the file will automatically give me a number churned from the...
Summary: How can I create a print button in excel so that the user by clicking it will get the whole document printed? BUT The page must not have any backgroun...
Summary: Hi. There is a common problem with dates in xcel spreadsheets between Amercan and UK formats (mm-dd-yyyy vs dd-mm-yyyy). I want the latter, but no mat...
Summary: I have a very strange problem with my computer, some time ago I started with a problem when trying to use the "/" symbol in excel 2000, quattro pro 7 ...
Summary: User has an excel spreadsheet created in Excel 2000. The spreadsheet is fairly simple, a listing of meetings with several filters inserted. The user t...
Summary: I want to sample a cell in Excel and if it is empty, I want to delete that row. I can delete a row using the row number but can't do it using a variab...
Summary: Some options in my insert cell menu have mysteriously disappeared! If I choose several cells in Excel 2000 then right click and choose insert, a box p...
Summary: i have two different workbooks, in one workbook i have put in radial buttons, in the other workbook i want in to put something in a specific cell when...
Summary: Within a specific Excel 2002 Spreadsheet that I have, I am unable to change the color/fill of specific cells. I can change the color/fill of cells in...
Summary: I have dat in ONE EXCEL SHEET. for data in cell AA1:AA12 I have created a combo box. Data1 1) English Songs 2) Hindi Songs 3) Poems Data2 there are th...
Summary: Hello, I recently was copying some information from Access 2000 to Excel 2000 during which for some odd reason my Excel menubar disappeared. I tried ...
Summary: I have found all the above comments helpful, but wondered if anyone knew of a way to partially protect a cell. I might explain myself better by giving...
Summary: Hi, I currently have date displayed as 12-Jan-01 and i would like it to be formatted to yyyymmdd, if there a formula i can use? can anyone help?? tha...
Summary: is it possible to open .xls files created in "Excel 2000", in a machine running "Excel 95" does it need any add-ons my signature does not look like th...
Summary: Lotus 123 user creating a large spreadsheet for an Excel customer. In Lotus I have the ability to change the color of each Sheet's Tab. Is there a way...
Summary: Ok, I have a spreadsheet with 500 rows and the first column has a date in it. The date comes up as 2003. It should be 2001. Is there a way to chang...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
