| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 43934 | 2004-04-01 06:34:00 | Excel function help | Mike (15) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 226492 | 2004-04-04 23:10:00 | OK. But just for completeness, a couple of further things: 1. I don't know how to prevent Excel from formatting things like 25/12 as Xmas day etc. I don't think it can be done. Even going into control panel and changing the system date separator makes no difference. 2. The approach I suggested is to recover the numbers you want AFTER Excel has automatically date-formatted them. 3. As far as I can tell, my above suggestions all work fine, EXCEPT that you may have to watch out for the special case where the number after the slash is 2004. That one's not hard to resolve tho' and I'm sure you won't have any trouble in sorting it out if need be - just find out what Excel actually does in this case. |
rugila (214) | ||
| 1 2 | |||||