|
-
Mar 10th, 2009, 05:17 AM
#1
Thread Starter
Don't Panic!
[RESOLVED] [Excel 2003] Weird Year problem
Probably me being thick but....
Have a sheet of data, one field it date/time (dd/mm/yyyy hh:nn:ss).
Copied the data from Access. Pasted into Excel
The date I have visible is : 19/01/2009 18:59:00
Note the extra space in between the time and date. I removed it - Excel put it back.
Year coming out in another cell is : 1905
Please tell me its something I'm doing wrong...
Feeling like a fly on the inside of a closed window (Thunk!)
If I post a lot, it is because I am bored at work! ;D Or stuck...
* Anything I post can be only my opinion. Advice etc is up to you to persue...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|