can I write jan1 or feb1 or something like similar in value I try to write but excel automatically converts it into number value

[tahir573]

Assalam-u-Alaikum (Hello) everyone, please help me in excel 2002, I want to write value jan1 in cell e15,
feb1 in g15, mar1 in i15 than jan2 in e33, feb2 in g33 and mar2 in i33. but when I write jan1 or something
similar excel automatically converts it to number value i want jan1 and other in value is it possible please
help me.

 

[nbrcrunch]

format the number as a date.

 

[Dave Patton]

Format the cells as text before entering the "Jan1" or prefix the info with single quote like 'Jan1.

or


If you wish to leave as a date, Custom Format the cell as mmmdd.