| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Coverting dates
Hi Group,
I have inherited a large spreadsheet full of payments (about 5000 of them). Some dates are entered like so 01/01/04, 01/1/2004, 01.01.04, 01.1.2004. Excel does not recognise the dates with full stops in them. Is there a fast and efficient way for me to convert and standardise all dates to dd/mm/yyyy? Regards Tony |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Coverting to minutes | Excel Discussion (Misc queries) | |||
| coverting h:mm to decimal | Excel Discussion (Misc queries) | |||
| Coverting seconds into hr:min:sec | Excel Discussion (Misc queries) | |||
| Coverting time | Excel Worksheet Functions | |||
| Coverting a VBA array from 2-D to 1-D | Excel Programming | |||
Threaded Mode
