Hi !
Usually results of Football (Soccer) matches are given like 3:1, 2:2, 0:1. See picture“ORIGINAL”
ORIGINAL
12. kolo GERMANY 1
Dan Cas R.b. 45' 90'
Sub 15:30 5201 Bayern M. Cottbus 1:1 3:1
Sub 15:30 5202 S Hannover Bochum 1:1 2:2
Sub 15:30 5203 S Hansa Dortmund 0:1 0:1
Sub 15:30 5204 S Hertha Hamburger 0:0 2:0
Sub 15:30 5205 S K'lautern München 1860 0:0 0:0
….When I want to copy these results and after that to paste them into EXCEL, they are changed. After the paste they become 3:01, 2:02, 0:01……… and so on.
See picture “RESULT OF PASTING IN EXCEL”
RESULT OF PASTING IN EXCEL
12. kolo GERMANY 1
Dan Cas R.b. 45' 90'
Sub 15:30 5201 Bayern M. Cottbus 1:01 3:01
Sub 15:30 5202 S Hannover Bochum 1:01 2:02
Sub 15:30 5203 S Hansa Dortmund 0:01 0:01
Sub 15:30 5204 S Hertha Hamburger 0:00 2:00
Sub 15:30 5205 S K'lautern München 1860 0:00 0:00
Is there a way to prevent this change of format to TIME.
The best thing would be to place result in two columns like :
Bayern M. Cottbus 3 1
Hannover Bochum 2 2
Hansa Dortmund 0 1
If it is possible.
Thank you in advance
DORDE
Usually results of Football (Soccer) matches are given like 3:1, 2:2, 0:1. See picture“ORIGINAL”
ORIGINAL
12. kolo GERMANY 1
Dan Cas R.b. 45' 90'
Sub 15:30 5201 Bayern M. Cottbus 1:1 3:1
Sub 15:30 5202 S Hannover Bochum 1:1 2:2
Sub 15:30 5203 S Hansa Dortmund 0:1 0:1
Sub 15:30 5204 S Hertha Hamburger 0:0 2:0
Sub 15:30 5205 S K'lautern München 1860 0:0 0:0
….When I want to copy these results and after that to paste them into EXCEL, they are changed. After the paste they become 3:01, 2:02, 0:01……… and so on.
See picture “RESULT OF PASTING IN EXCEL”
RESULT OF PASTING IN EXCEL
12. kolo GERMANY 1
Dan Cas R.b. 45' 90'
Sub 15:30 5201 Bayern M. Cottbus 1:01 3:01
Sub 15:30 5202 S Hannover Bochum 1:01 2:02
Sub 15:30 5203 S Hansa Dortmund 0:01 0:01
Sub 15:30 5204 S Hertha Hamburger 0:00 2:00
Sub 15:30 5205 S K'lautern München 1860 0:00 0:00
Is there a way to prevent this change of format to TIME.
The best thing would be to place result in two columns like :
Bayern M. Cottbus 3 1
Hannover Bochum 2 2
Hansa Dortmund 0 1
If it is possible.
Thank you in advance
DORDE