| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Date Formats
Select your data range then go to menu
Data Text to Columns Next Next under Column data format select Date DMY Finish Custom Format dd.mm.yy It will convert all text dates to real Excel dates "Gary" wrote: Help please. We've entered thousands of entries with the date format dd.mm.yy - i.e. 15.02.07 Excel doesn't recognise this format (the nearest would appear to be 15.2.07) and therefore won't allow us to customise a date range. We've tried changing one of the date formulas to match the above but still can't get it to work. Any idea? Please remember......not an IT expert so as simple as possible please. Thanks -- Gary |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel copied cells not recognising date formats | Excel Discussion (Misc queries) | |||
| Text, Number and Date formats excel 2003 driving experienced user | Excel Discussion (Misc queries) | |||
| excel date formats changed | Excel Worksheet Functions | |||
| Excel 2003 is changing my date formats | Excel Worksheet Functions | |||
| Excel date formats | Excel Discussion (Misc queries) | |||
Linear Mode
