Excel converts text to date

[Dona]

Problem with Excel 2010. Excel converts cells to a date format. I want it as typed. I tried to format the column to text. This did not work.

I typed the following text in each row:
August32
April85
Dec90
Aug22

Please help. I do not want Excel to convert the above to a date.

Thank you for your time.

 

[MarkK]

In Excel 2007 you can highlight a range of cells, right click, select 'Format Cells ...', select the 'Number' tab, and select 'Text' in the list marked 'Category.' This preserves your entry text as typed, but be careful, it will convert your existing dates to numbers.
HTH