Hi,

Do the following;

1. Select the Cell or range
2. On the Format menu, click Cells.
The Format Cells dialog box is displayed.
3. Click the Number tab.
4. In the Category list, select Text.
5. Click Ok to apply the format to the range in the Worksheet.

Challa Prabhu

"jxbeeman" wrote:

Okay! I am importing part numbers into excel and some of the part numbers get
automatically changed into dates because of the format. for example 7-40
turns into Jul-40. How do I turn off this auto data editing so my numbers
don't get changed.