Summary: Please help. I want to use a date formula to find the difference between 2 dates. I know the formula but, when I apply it to a worksheet, a number app...
Summary: Hello! Please help me a little with Date formulas in MS Excel 2000. I have a Cell (A1) with a 'dd.mm.yy' value, and i wanna make Excel to calculate H...
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: Excel error: a formula in a cell (Name:[filename]worksheet!(Unititled) could not be converted because it contains a function that is not available in ...
Summary: I am trying to perform a “what-if” analysis on a worksheet using an Excel 2002 program but using an Excel 2000 textbook as a guide. It does not compu...
Summary: I have a question about write a simple sum formula in Excel of MS Office 2000. I want adding every nine line number togather, example: sum = c5 + c14 ...
Summary: I have a question about write a simple format in Excel of Office 2000. I want adding every nine line number togather ( example = c5+c14+c23+c32 ... un...
Summary: wheni am entering 6/30/2005 in my excel sheet it is appearing as 38533 (i guess numeric value of date) however in function bar it appears correct as 6...
Summary: http://www.computing.net/answers/of... I have got same issue in the link above, how can I change date format in Excel 2003 to dd/mm/yy (28/03/09),,,,t...
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: One of our users is having a problem with merging cells in excel 2002. She cannot merge cells, but only in one worksheet. The merge button is even gra...
Summary: OK, I have a weird problem. A couple of weeks ago, at work, I was playing with some of the configuration settings in Excel. Nothing major, on a late F...
Summary: Have an extensive worksheet in Excel 2002 which I use daily and suddenly, every time I make a change to a font(bold,italic,etc) and then try to save i...
Summary: Hi I'm trying to work out how to devise a formula in Excel 2003 which does the following ... Searches a range of cells for a certain text value 'False...
Summary: - Right click the sheet tab. - The bottom choice should be View Code (at least in Version 2003 and earlier) - Click View Code - A blank VBA Editor win...
Summary: Thanks, I didnt realize changing the way the date looked on your desktop (lower right corner) affected the ay the date appeared in all of MS applicati...
Summary: Im sorry you lost me on that last post. I'm not very good with Excel. what do you mean put in the ranges? I attempted that formula in just one cell...
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: I need to Sort an entire row by date automatically (close of escrow). I would like to be able to hit a button and the sheet sorts all the rows by date...
Summary: Excel 2002 doesnt open in XP, but works fine in windows2000.I get the following error "errors were detected in "filename.xls" , but microsoft excel wa...
Summary: i am trying to use an array formula to select certain cases from an adjacent work sheet and comute percentiles. The problem I am having is that there ...
Summary: Hi This problem is really bugging me. I reloaded Office 2002 and all went well. But ... I can only set the date to American format. i.e. 2.24.2005 and...
Summary: Hi, I have a problem, I have a column (lets say column A) in Excel that contains data of type date, I converted it to date using the formula DateValue...
Summary: In an excel file I have a list of names and want people to enter comments for the latest status. Is there a way for excel to calculate that date the c...
![[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
