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: Hi, The formulas for conditional formatting that DerbyDad03 gave you do work in Excel 2007. Maybe you didn't enter them correctly. Excel 2007 has a lo...
Summary: Okay. Now I understand what you are trying to do. The only way I know of is to use VBA code. You would have to convert the raw number into a format t...
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: Last week while entering data into Excel, I noticed that it started making me enter the date in opposite (example, instead of entering 07 10 for July ...
Summary: My newly installed excel 2003 cannot display the changes to cell formatting, i.e.the color of the word and fill of the cell, but it can display normal...
Summary: Could anyone provide the formula to solve the following I Have my Start time and end time and I know how to format the cell, what I want to do is subt...
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: 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: Hi: I'm trying to highlight the larger of two data columns side by side on the same sheet. ie: a1 3 b1 4 a2 6 b2 5 I want the larger of the two highl...
Summary: I dont understand your formula. It appaear to be adding two values and subtracting a third. To find the difference between two dates it is just date1...
Summary: Hello, how to set the type (text, number, date,..) of column in EXCEL with VBA? (not manually through Ctrl+1 -> Format of Cells ->...) Thanks for your...
Summary: Hi all, does anyone know how to do this? In Excel 2003 I used the function "URLEncode", but it seems this no longer exists in 2007. Many hours search...
Summary: Hi RayMan, I've already try this, and it dosn't work. When I'm launching Excel XP, and I go to the Page Setup, the drop list is blank instead of the r...
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: You use linking for the Word piece (look it up in the help files, theres oodles of useful stuff there. Essentially, the easiest way is to copy your so...
Summary: hello.is there any way i can scan a plain text document to my computer.then open it in excel,and configure it to be in an .xls format.which will allow...
Summary: I recently did a survey for a grad school project, and my results were rolled up in Excel. For questions where more than 1 answer could be given, the ...
Summary: Hello, I have set up a simple timecard in Excel. There is a time field for clocking in, and another for clocking out. I want Excel to then calcul...
Summary: in excel xp, i have a list of items spanning 10 rows and 5 columns. the first column contains text, and i can sort by that column easily, however, i h...
Summary: I am creating a shared sign-in sheet that shows who is still waiting to be seen. I am using the following function: =IF(B2>"",IF(E2="","WAITING","") T...
![[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
