Welcome to YTUnity

One free SpiderTaz Network account works across every network site.

How to Stop Excel from Turning Numbers into Date

Max Dalton Guide Today

Description

In this video I'll show you how to stop Excel from turning numbers into dates. If you type something like 2-14 or 3/10 into a cell, Excel assumes it's a date and changes it. Here's how to keep your numbers exactly the way you type them.

Timestamps:
Introduction: 0:00
Format Cells as Text: 0:20
Type an Apostrophe First: 2:06
Conclusion: 2:29

Check out my website for other great tutorials about all kinds of technology: https://maxdalton.how/

Support this channel by becoming a member: https://www.youtube.com/channel/UCBbDWMccTJCL0WmbMHNLZIw/join

#excel #microsoftexcel #exceltutorial #techtips #tutorial

Video Transcript:
Step 1. Open your Excel spreadsheet. For this example, I'm using a grading log for a comic book shop, and I want to enter the volume and issue number in the Vol-Issue column, like 2-14 for volume 2, issue 14.

If you type 2-14 into cell B2 and press "Enter," Excel changes it to 14-Feb, and the formula bar shows a full date. Press "Ctrl" and "Z" to undo it before you continue.

Step 2. Click the letter B at the top of the column to select the entire Vol-Issue column.

Step 3. Right-click the selected column, and then click "Format Cells." The Format Cells window opens.

Step 4. Make sure the "Number" tab is selected at the top of the window, click "Text" in the Category list on the left side of the window, and then click "OK."

Step 5. Click in cell B2, type 2-14, and then press "Enter." Excel keeps the entry exactly as you typed it instead of changing it to a date.

You need to format the cells as Text before you type your entries. For example, if cell B3 isn't formatted as Text and you type 2-14, Excel turns it into 14-Feb. If you then select cell B3, press "Ctrl" and "1," click "Text," and click "OK," the cell shows a long number like 46067 instead, which is how Excel stores dates. You'll need to retype those entries after you change the format.

If you only need to fix one or two cells, type an apostrophe before your entry. Click cell B4, type '2-14, and then press "Enter." The apostrophe tells Excel to treat the entry as text, and it doesn't show up in the cell. You'll only see it in the formula bar.

Featured creators

Creators on the SpiderTaz Network

Become a creator →