How can I change separated numbers from turning into date format?

[Davebro]

0-2 1-2 3-4				0-2	01-Feb	03-Apr
1-2 0-0 1-1				1-2	0-0	01-Jan
1-0 2-0 1-1				1-0	2-0	01-Jan
2-3 1-0 0-1				2-3	1-0	0-1
2-1 1-0				2-1	1-0
2-1 3-0 0-2				2-1	3-0	0-2
2-0 1-1 2-2				2-0	01-Jan	02-Feb
3-0 1-1				3-0	01-Jan
1-0 2-0 1-3				1-0	2-0	01-Mar
2-1 3-0 1-1				2-1	3-0	01-Jan
1-0 1-1				1-0	01-Jan
1-0 2-1 1-2				1-0	02-Jan	01-Feb
2-1 0-1 1-0				2-1	0-1	1-0
1-1 2-0 2-1				1-1	2-0	02-Jan
3-0 3-1 4-0				3-0	03-Jan	4-0
1-1 2-2 0-0				1-1	02-Feb	0-0
1-0 2-0 2-1				1-0	2-0	02-Jan
0-1 0-2 1-2				0-1	0-2	01-Feb
1-0 2-0 2-1				1-0	2-0	02-Jan
0-1 1-2 1-1				0-1	01-Feb	01-Jan

 

[Fluff]

How are you separating them?

 

[Davebro]

How are you separating them?

Tried various ways this one was text to to columns,

 

[Fluff]

In that case with text to columns on page 3 of the wizard select all three columns in the Data preview pane & then select Text as data format, then click finish.
Before doing that make sure that the destination cells are formatted as general or text.

 

[Davebro]

In that case with text to columns on page 3 of the wizard select all three columns in the Data preview pane & then select Text as data format, then click finish.
Before doing that make sure that the destination cells are formatted as general or text.

Yes that is what I am doing but some still come out date .

 

[Fluff]

That works for me as long as the destination range is formatted to General before hand.

 

[Fluff]

Another option using a formula

+Fluff v2.xlsm
	A	B	C	D	E
1	0-2 1-2 3-4		0-2	1-2	3-4
2	1-2 0-0 1-1		1-2	0-0	1-1
3	1-0 2-0 1-1		1-0	2-0	1-1
4	2-3 1-0 0-1		2-3	1-0	0-1
5	2-1 1-0		2-1	1-0
6	2-1 3-0 0-2		2-1	3-0	0-2
7	2-0 1-1 2-2		2-0	1-1	2-2
8	3-0 1-1		3-0	1-1
9	1-0 2-0 1-3		1-0	2-0	1-3
10	2-1 3-0 1-1		2-1	3-0	1-1
11	1-0 1-1		1-0	1-1
12	1-0 2-1 1-2		1-0	2-1	1-2
13	2-1 0-1 1-0		2-1	0-1	1-0
14	1-1 2-0 2-1		1-1	2-0	2-1
15	3-0 3-1 4-0		3-0	3-1	4-0
16	1-1 2-2 0-0		1-1	2-2	0-0
17	1-0 2-0 2-1		1-0	2-0	2-1
18	0-1 0-2 1-2		0-1	0-2	1-2
19	1-0 2-0 2-1		1-0	2-0	2-1
20	0-1 1-2 1-1		0-1	1-2	1-1
Main

Cell Formulas
Range	Formula
C1:E20	C1	=TRIM(MID(SUBSTITUTE($A1," ",REPT(" ",10)),COLUMN(A1)*10-9,10))

 

[Davebro]

Another option using a formula

+Fluff v2.xlsm
	A	B	C	D	E
1	0-2 1-2 3-4		0-2	1-2	3-4
2	1-2 0-0 1-1		1-2	0-0	1-1
3	1-0 2-0 1-1		1-0	2-0	1-1
4	2-3 1-0 0-1		2-3	1-0	0-1
5	2-1 1-0		2-1	1-0
6	2-1 3-0 0-2		2-1	3-0	0-2
7	2-0 1-1 2-2		2-0	1-1	2-2
8	3-0 1-1		3-0	1-1
9	1-0 2-0 1-3		1-0	2-0	1-3
10	2-1 3-0 1-1		2-1	3-0	1-1
11	1-0 1-1		1-0	1-1
12	1-0 2-1 1-2		1-0	2-1	1-2
13	2-1 0-1 1-0		2-1	0-1	1-0
14	1-1 2-0 2-1		1-1	2-0	2-1
15	3-0 3-1 4-0		3-0	3-1	4-0
16	1-1 2-2 0-0		1-1	2-2	0-0
17	1-0 2-0 2-1		1-0	2-0	2-1
18	0-1 0-2 1-2		0-1	0-2	1-2
19	1-0 2-0 2-1		1-0	2-0	2-1
20	0-1 1-2 1-1		0-1	1-2	1-1
Main

Cell Formulas
Range	Formula
C1:E20	C1	=TRIM(MID(SUBSTITUTE($A1," ",REPT(" ",10)),COLUMN(A1)*10-9,10))

This has solved it, many thanks for your time.

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Dossfm0q]

or by using Apostrophe '