How to format date in Excel?
494594
Go to Format > Cells on the main menu, and on the number tab, select Date.  Then you can pick any date format you want.  You can also just go to the bottom of that list and click "Custom".  Then enter the text dd-mm-yyyy and that will format it the same way that you want (European convention).\n\nThe format that Excels displays will be exactly what you tell it to display in the Custom format area.  In the the US and (I believe) India, date formats are Month-Day-Year.  In most of Europe, it is Day-Month-Year.  If you want it to display Day-Month-Year, then just enter the format of dd-mm-yyyy.  If for some reason you wanted Year-Month-Day, then you would just give a custon format of yyyy-mm-dd.  Excel will format it exactly as you instruct it.
1150128
Create an expression field in your query with the expression DateString: Format([DATE],"yyyymmdd")\n\nWhere DateString is whatever you choose to name the field and [DATE] is the name of the field you need to express as a string.\n\nIt may also be possible to create an Input mask in the format you want but I failed to hack that! The above is by far the easiest and most logical method, anyway, since you want to represent the data already in a table, not change the way it is input.
930016
Right click on that cell and go to Format Cells.  Now, go to the Alignment tab and check the box that says "Wrap Text"
661261
You could use conditional formatting on the cells where you are entering your data.  But you actually don't need to do conditional formatting, it's just that you can get smoother more interesting effects if you do.  An easier way might be a simple formula.\n\nIt sounds like you are entering data that uses Case numbers, but if you have already entered a case, you don't want to do it again.  Obviously you could just search the case number column to see if it already exists and if so, then skip entering it.  But a more automated way would be easier.\n\nThe essence of what you need to do is use a formula to tell you if what you just entered already exists in the rows above. (To use your example, does case 24 exist already in the rows above A27?)\n\nYou could insert a (temporary) column to the left of what you are typing in.  In that column you would enter a formula to count the number of instances where the case number you just entered already exists above.  Usually the result would be 1, sometimes 2.\n\nLets say you are on row 27 and your case numbers are in column B, and your counting column is column A.  Lets assume your data starts on row 2 at the top of the spreadsheet.  Your formula for cell A27 would be:\n=IF(COUNTIF($B$2:B27,B27)>1, "Exists Already!", "")\n\nNotice the $ signs in the Countif formula.  The formula range will adjust as appropriately as you copy it around.  You want to get this formula on every line next to every case number so that it can alert you if it seen there is more than once instance.\n\n(Actually the Data Validation mentioned below is a better solution because it will prohibit you from entering the data.  But it's all the same principle. Just more elegant because you don't need to insert a new column.)
182601
If you are using Windows. Go to commant prompt,\nwrite 'format /?' there. You will find how to format
573840
Best is to format the cell by right clicking on it....and choosing format cells....under Number tab choose Custom...and type format as 000 (no. of zeros upto the digits u require)....and enter..\n\nBy doing so ull be storing numbers as numbers and with leading zeros....\n\nI dont agree with typing '048 as it stores numbers as text\n\n\nhope this clarifies ur doubt
569995
Are you trying to get rid of the blanks?\n\nOne way is just to sort the column--that will pull all the blanks to the top or bottom, where they are easy to delete.\n\nIf you need to keep the order that values are in, try this:\n\n1. Select the entire column.\n2. On the edit menu, choose "Go to..." then click "Special..."\n3. In the box that comes up, choose "Blanks" and hit OK.\n\nYou should now be back in the sheet, with all the blank cells selected.  Right click, choose "Delete...", then choose "Shift cells up" and hit OK.\n\nThis is for excel 2002, it might be a little different in other versions.
957828
Just open it with Excel.  It will automatically populate the columns.\n-MM
115616
1. Open Microsoft Word\n2. Right Click on Toolbar\n3. Select CUSTOMIZE\n4. Select COMMANDS tab.\n5. Select FORMAT from left Column\n6. Drag SuperScript from Right Colum and drop it to Toolbar\n7. Drag SubScript from Right Column and drop it to Toolbar
1062293
I think its called conditional formatting. If value is cell b2 is greater than value in cell c2 then format cell b1 with bold color italics etc.
707324
Select the time or date object and click on Insert.\nChoose Date and Time and remove the tick from 'Update automatically' and click OK.  The date and time will revert to normal text.
252390
I'm going to e-mail you an Excel spreadsheet that will do it.   Don't change anything except the dates and the yellow cells and everything else will automatically calculate.
916539
1.  Open Excel\n2.  On the top tool bar click the question mark\n3.  In the Office Assistant text box \ntype in\nCalculate the difference between two dates\n\nYou will be given the step by step instructions.\n\nk\np.s.  Use the Office Assistant for \nlots of functions \nincluding getting all sorts of formulas.
841977
I assume you're using Excel.\nUse the following formula:\nAlso assuming the smaller date is in cell A1, and the larger date is in cell B1.\n=N(B1-A1)\n\nThe serial numbers for dates in excel are always in days - so if it was 1.5, that's one and a half days, and if your answer was 365, then it's one year.\nKeep in mind that one day = 24 hours, so if you were trying to count the days between two times, and you use right now  (found with the now() function), and then yesterdays date with a time later than right now, you'll get a number less than 1.\n\nTo avoid this, you'd have to use something like this:\n=N(ROUNDUP(B1+1/86400,0) - ROUNDUP(A1+1/86400,0))\n\nThat formula rounds the serial number of each date up to the nearest day, before subtracting. In case you're wondering, in excel the serial number for one second can be found by using 1/86400. The +1/86400 is used to add one second to your times. The reason for that is that excel counts the time for exactly midnight as if it were on the previous day.  Adding one second takes care of this.\n\nThis would make the time irrelevant, so you'd get the same answer if finding the days between\n11/21/2006  11:59:59 PM and 11/22/2006  12:00:01 AM\nas you would between\n11/21/2006  11:59:59 PM and 11/22/2006  11:59:59 PM\n\n\nSO to sum it all up:\nIf you want to count the number of "24 hour periods" between two dates/times, then use:\n=N(B1-A1)\nIf you want to count the number of days between two dates/times, but not taking the times into account for purposes of determining the days, then use:\n=N(ROUNDUP(B1+1/86400,0) - ROUNDUP(A1+1/86400,0))
206954
Excel stores dates and times in days.  If you subtract one time from another, the result will be in days.  Multiply by 24 to convert to hours.\n\nTo display tenths of an hour, format the cells to display tenths.\n\nTo always round up, add 0.05 hour.\n\nFor example, an employee starts work on March 12, 2006 at 8:05 and punches out at 5:11.  When you subtract the start time from the end time, you get 0.3796 days.  To get hours, multiply by 24: 9.11 hour.  To round up, add 0.05 hour: 9.16 hour rounds to 9.2 hour.
79970
right click on cell, select format cell.
130036
1. Start Microsoft Excel\n\n2. Before you type fractions in cells, preformat the group of cells that need to be displayed as fractions. Select the cells where you want to enter fractions, and then select Cells from the Format menu.\n\n3. Click Fraction in the Category list, and then, from the list on the right, select the type of fraction that you would like to display. Click OK.\n\n4. Now you are ready to type fractions in these preformatted cells. To type fractions in cells, just type the numerator, followed by a slash (/), then followed by the denominator—do not type spaces.\n\na. For example, 1/2 would represent one-half, as would 4/8 (Excel reduces fractions to their lowest terms). If you need to type a whole number and a fraction in one cell, type the whole number followed by a space, and then type the fraction (numerator, slash, denominator).