Excel treats my text as number that is a date

[ammykhan]

23/04/2

4/18/3

4/25/3

4/20/4

55/23

100/66

4/28/4

4/24/4

23/44

56/15

80/50

75/50

66/47

4/35/4

4/41/4

95/46

52/32

87/52 & 2.3/18/1

71/37

103/60

66/34

94*/51

4/40/5

96/64

4/24/2

3/19/2003​

116/64

4/22/2

4/25/2003​

103/62

88*

56*/31

4/25/5

3/14/4

51/39

99/57

4/33/4

4/35/3

44/21

68/41

4/18/5

87/49

4/10/5

63/49

89 & 2 wickets

4/16/2003​

 

[ammykhan]

Automation is great tool in excel and it reduce our workload but at sometime it leads to unnecessary problem that can be avoided otherwise, here I'm trying to put the record of each player into excel, for example I fill a cell with 4/16/3 which is summary of his bowling i.e the number of overs bowled, runs given by him, and the wickets taken in those four overs by the bowler. But strangely excel treat it as 4/16/2003, I used TEXT(A2,"D/MM/Y") function to convert it to text, but it is very time consuming to do it for all the individual records, fill down just copies the text from the above cell. Need help how to automate the process and let excel know that the string is just a text and don't treat it as a date.

 

[GWteB]

If you don't want Excel to do that, explicitly format the column in question as Text before entering any data.

 

[ammykhan]

Ok thanks, yes it might work, that is nice from you, I wondered how I can resolve the issue, tried different things to get it done