dates

A reader asked if there was any formula in Excel that would convert a date shown in the European format of day-month-year to the U.S. version of month-day-year. Technically, it may not be necessary to do this. Excel maintains dates as numeric values ... and displays them using various formats. If the dates are numeric values in your worksheet, then you can simply change the format and the dates will be displayed in the U.S. format. The day you see in a worksheet could instead be a text value rather than a numeric value. To see if the date is truly an Excel date or text value, you can change the ... (view more)

When you're in a meeting and you are trying to set up the next meeting, you need to find the dates fast. In Outlook 2007 that is no longer a problem! To find a date quickly, follow the steps below: Choose Go | Go To Date. Or press CTRL + G. The ... dialog box appears with a date highlighted. To go to another date, type the day you want as you normally would. There is another really cool way to change dates in Outlook 2007. You can type in something like "thirty days from now." Outlook understands English when it comes to dates. I'm not sure if you want to use that feature all the time, ... (view more)

When entering numbers in Excel you can type the numbers into a cell by using the keys on the top row of the keyboard or, if Num Lock is turned on, by using the keypad on the right side of the keyboard. To do so, follow the steps below: Type the ... numbers in the cell and press Enter. If you type decimals, such as 1.5000, Excel often eliminates the trailing zeros and displays 1.5. Note that another future article will tell you how to control this. You can also type dollar signs, commas, or percent signs, and Excel displays them with the numbers. Even when you type these symbols, Excel interprets ... (view more)