| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Date Formats
Format Cells... Number Custom
dd.mm.yy And then enter your data -- Gary's Student gsnu200706 "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 Date Formats | Excel Discussion (Misc queries) | |||
| Excel copied cells not recognising date formats | 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
