How do I disable Excel 2003 from automatically recognizing dates?

1. Select the cells that will be formatted as dates.

2. Select the menu "Format Cells" (or directly right-click on the cells and select "Format Cells").

3. Click the "Number" tab in the "Format Cells" window that opens, select "Text" in "Classification" and "OK".

Hello, please don't be in a hurry. Just follow my steps.

1. First of all, delete all the "dates" you copied. (The premise is that it can be copied again) 2. Select the column to paste, and right-click the "Set Cell" "Number" text.

3. Just copy and paste your scores into this column.

<> hope to help you.

Set the cells that are to be placed with the "-" symbol to text formatting, and select the paste option "Match target area format" when pasting.

Select those cells Right-click ---format cell---number---general

Double-click the cell and then paste it to avoid recognition.

Before pasting, format the cell range as text format.

Tools Raw materials.

Excel2003 PC.

Method steps.

1. First of all, switch the input method to the English half-width symbol state, enter single quotation marks, and then enter "2 3".

2. The display as "2 3" does not become a date.

3. You can also select a cell, right-click with the mouse, and click "Format Cell".

4. In the pop-up number tab, select "Text".

5. Directly enter "2 3".

1. First switch the input method to the English half-width symbol state, enter single quotation marks, and then enter "2 3".

2. Look, it is directly displayed as "2 3", and the single quotation marks are not displayed, nor do they become dates.

3. In the Number tab, select the category as "Text".

4. Enter "2 3" directly to see if it is not converted to date.

Method 1:

1. Select the cells you want to modify (can be multiple cells).

2. Select the menu "Format Cells" (or directly right-click on the cells and select "Format Cells").

3. Click the "Number" tab in the "Format Cells" window that opens, select "Text" in "Classification" and "OK".

Method 2: 1. Add a single quotation mark in front of the input content, which is to tell Excel to process the content after the single quotation mark as text (the single quotation mark itself will not be printed).

2. After the input is completed, press Enter.

Select the cell you want to cancel, right-click "Format Cell" - change "Time" to "General" in the "Number" option.

Add before the number'

For example, if a1=10-1 is changed to a1='10-1

1. Create a new excel file, Ctrl+A to select all, right-click, and format the cells as text.

2. In the original excel file, Ctrl+A select all, Ctrl+C copy 3, in the new Excel file, menu bar - paste selective - only keep the value 4, in the new excel file, Ctrl+A select all, Ctrl+C copy 5, in the original Excel file, Ctrl+V paste 6, set the format of the cell where the above data is located to the date type.

Just format the cells and set them to the format you want. Or add one before the content'symbol, see this inconspicuous''''''''''''''''''''Before you enter something, just enter one. You can try.

Can't cancel, first set the cell to text format, and then input your data.

Most of them don't understand what you're asking for.

Before typing, enter a dice break. “'Got it, I didn't understand it and asked a question.

When pasting, right-click "Paste Special" and select "Text".

Just set it up in Customization.

Excel input numbers automatically become dates because the format of the cells with input values is set to date, and there will be no such situation after the cell format is set to regular or numeric values, as shown in the following figure:

Formatting cells as text will do just that.

However, even if it is formatted as text, if the characters you enter conform to the date format, they still have a date attribute. For example, if you enter 10-20, the result obtained by using the function year is still 2015.

Select the column you want to set, right-click - format the cell, select the text in "General", and then OK.

Select the cell, right-click --- format the cell", pop-up window -- change the option to:"Text";

Format – Cells – Number option, select regular or text format.

Plus one in front'number on the line.

Select the cells you want to set in excel, click right-click - format cells - numbers, there are many categories in it, you can choose the format you need.

Right-click on the cell - Cell Format - Number - General.

Right-click in the cell you want to execute, select Format Cell, select Date, and then select the format you want.

When you're splitting, e.g. 3-15, you can set 3-15 as text. As shown in the figure below.

Formatting it as text won't be automatically converted.,Are you setting this wrong?。