When i work with excel, i do data entry, some of the numbers that i type in can

Question

When i work with excel, i do data entry, some of the numbers that i type in can be interpenetrated as dates. when this happens excel automatically changes the format of the cell from general, to date. i want to be able to stop this auto correction.

I know there are a number of ways to avoid this happening, but i am fed up with these methods. i simply what to turn the auto correct off, so that instead of what i type into the cell changing, what i type into the cell shows exactly what i typed in.

really hope there is someone out the who knows how to do this.

thanks!!!!

Explanation / Answer

If you format the cells as Text, all entries will be entered as text
(leading zeroes will be retain, date-like values won't be converted to dates, etc)
...CTRL+1 (to view the formatting dialog window)
...Select: Number_tab...Category: Text

That should resolve most (but not all) of the problem.

Does that work for you?

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.