| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to set the cell for date?
When I import the data from following link, its date format is mm/dd/yy
instead of dd/mm/yy, therefore, the cell will recognize 03/10/09 to be 3 Oct, 2009 instead of 10 Mar, 2009, however, the recognized error occurs on 03/17/09 for a valid date format. Does anyone have any suggestions how to retrieve the right date format from importing following link? http://www.ustreas.gov/offices/domes...te/yield.shtml Thanks in advance for any suggestions Eric |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically update a cell with a date based on anther cells date | Excel Discussion (Misc queries) | |||
| Date Turns Green 90-Days before the date shown in cell | Excel Worksheet Functions | |||
| Create a button that will date stamp todays date in a cell | Excel Discussion (Misc queries) | |||
| formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
| Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
Threaded Mode
