To enter a value in Excel, select a cell, type a number, text, date, or formula, and press Enter. Excel stores the entry in that cell; the way it displays it depends on the data type and the cell’s number format.
What Excel Means by a Cell Value
A cell value is the information stored in a worksheet cell. It can be text, a number, a date or time, a logical value such as TRUE, or a formula. A cell may show a formatted version of its value: for example, the underlying number 0.25 can appear as 25% when the cell is formatted as a percentage. This distinction matters because formatting changes appearance, not the underlying data.
People sometimes use value to mean the result of a formula. If a cell contains =2+3, its formula is =2+3 and its calculated value is 5. The formula bar shows what is stored or calculated from the selected cell, while the grid shows the result using the cell’s current formatting. To inspect a cell, select it and look at the formula bar above the worksheet.
Entering and Editing Data
In Excel for Microsoft 365 on Windows, click a blank cell, type the entry, and press Enter to confirm it. Excel normally moves the selection down one row. Press Tab to confirm an entry and move one column to the right. You can also double-click a cell or select it and start typing to replace its contents. To change only part of an existing entry, select the cell and edit in the formula bar, or double-click the cell to edit directly.
Pressing Escape while editing cancels the change that has not yet been confirmed. After confirming an entry, Undo can reverse it; on Windows use Ctrl+Z, and on Mac use Command+Z. Excel for the web has similar cell-entry behavior, although ribbon layout and keyboard shortcuts can vary with the browser and operating system. A useful habit is to confirm each row before moving on and periodically save the workbook.
For structured records, use one row for each item and one column for each kind of information. For example, a simple inventory list might have columns named Item ID, Description, Quantity, and Count Date. Put the headings in the first row and avoid combining multiple facts in one cell. That layout makes sorting, filtering, checking, and later analysis much easier.
Text, Numbers, Dates, and Formulas
Excel interprets entries based on their contents and the cell’s format. A plain entry such as 42 is usually numeric and can be added or averaged. A word such as Pending is text. An entry beginning with an equals sign is treated as a formula. Dates and times are stored as serial numbers, then displayed according to the chosen date or time format. This is why a date can be reformatted without changing the date itself.
Identifiers often look numeric but should be stored as text. Product codes, postal codes, and account numbers may contain leading zeros or may never be used in arithmetic. If you enter 00421 into a General-format cell, Excel may display 421. To preserve the zeros, format the destination cells as Text before typing or importing, or type an apostrophe before the entry, as in ‘00421. The apostrophe signals text and is not normally shown in the cell.
Dates can also be ambiguous. Depending on regional settings, 03/04/2026 may mean March 4 or April 3. Use an unambiguous form such as 4 Mar 2026 when entering dates manually, or make sure the workbook’s expected date convention is agreed on. When an entry displays as a string of number signs, the value is often valid but the column is too narrow to show it; widen the column or adjust the date or number format.
Choosing and Applying Number Formats
Formatting controls how values look, and a suitable format makes a sheet easier to read without changing the underlying value. Select the relevant cells and use Home > Number Format to choose options such as General, Number, Currency, Percentage, or Date. For more control, open the Format Cells dialog from the number-format controls and specify decimal places, separators, or a custom display format.
Choose a format that matches the meaning of the data. Use Percentage for rates stored as decimal fractions: a stored value of 0.15 displays as 15%. If you type 15 and then apply Percentage, Excel may display 1500%, because the stored value is fifteen, not 0.15. For quantities, decide whether decimal places make sense. For codes that must preserve exact characters, use Text rather than a numeric format.
Do not use a display format as a substitute for correcting wrongly stored data. Applying a date format to text that resembles a date may not convert it into a usable date. Similarly, applying Currency to text containing a currency symbol does not necessarily make it a number. Check whether a cell behaves as expected in calculations before relying on it.
Faster Ways to Enter Repeated Information
For repeated values, copying or filling is generally more reliable than retyping. Copy a cell and paste it into the destination range when the same value or formula should appear in several places. For a sequence such as dates or consecutive numbers, enter the first entries, select them, and drag the fill handle at the lower-right corner of the selection. Excel uses the selected pattern to continue the series; inspect the filled results, since the pattern may not match your intention.
AutoComplete can suggest an existing text entry when you type in a column, which is useful for repeated labels such as department names. It is not a controlled vocabulary, though: small spelling differences can create separate categories. For lists where consistency matters, create a dropdown using Data > Data Validation and choose List as the validation criteria. You can provide the allowed options directly or refer to a range containing them.
For a block of records, paste a prepared rectangular range rather than entering each cell separately. Before pasting, check that the source columns line up with the destination headings. If the source includes formulas or formatting you do not want, use the paste options to choose an appropriate result, such as values only. After pasting, review the first and last rows and look for shifted columns or unexpected date and number formats.
Importing and Pasting Data from Other Sources
When data comes from a CSV or text file, importing it is safer than opening it blindly if columns contain dates, leading zeros, or mixed types. In Excel for Microsoft 365 on Windows, use Data > From Text/CSV, select the file, and review the preview before loading it. Check the delimiter, column boundaries, and detected data types. For identifiers, set the relevant column to Text during import where the available import options permit it. The preview is an opportunity to catch a code such as 00108 being interpreted as 108.
Copying from a website, email, or another workbook can bring hidden formatting, nonbreaking spaces, or values stored as text. A number aligned to the left may be text, though alignment alone is not definitive because formatting can change alignment. Test a sample in a calculation or inspect its format and formula bar. If columns arrive combined, Data > Text to Columns can split them using a delimiter or fixed-width positions. Preview the result and choose the correct destination so that the split does not overwrite other data.
Excel may show a warning when a number is stored as text. If the cell is meant to be a genuine number, use the warning’s conversion option where available, or re-import and specify the correct type. If it is an identifier, keeping it as text is usually appropriate. Avoid converting every text-looking number automatically: the correct choice depends on what the field represents.
Common Data-Entry Problems
- Leading zeros disappear: The entry was interpreted as a number. Format the cells as Text before entry, use an apostrophe for individual values, or import the column as text.
- Dates are reversed or misread: The source and workbook may use different regional conventions. Confirm the expected order and use an unambiguous date entry or import settings.
- A number will not calculate: It may be stored as text, include an unexpected space, or contain a character copied from another source. Inspect the cell and correct the data type rather than relying on appearance alone.
- Values display as ####: The column may be too narrow, or the selected number format cannot display the value at its current width. Widen the column and check the format.
- Duplicate or inconsistent labels appear: Entries may differ by spelling, spacing, punctuation, or capitalization. Standardize the source list and use a validation dropdown when appropriate.
For text that contains a number, the VALUE function can convert numeric text to a number if Excel recognizes its format. With the text 125 in cell A2, the formula =VALUE(A2) returns the numeric value 125. If the text contains an unrecognized separator or other characters, the conversion may fail; correct or clean the source entry first. A formula does not automatically solve every import or data-quality issue.
Keeping an Entry Sheet Reliable
Make the intended structure obvious before entering a large dataset. Use clear column headings, keep each field in its own column, and avoid blank rows inside the records. Turn a range into a table with Home > Format as Table to make headings and records easier to distinguish and to help filters expand as rows are added. Use Data > Filter when you need to view particular categories without deleting other rows.
For important lists, add checks at the point of entry. Data Validation can restrict a cell to a whole number range, a date range, or a list of permitted values. Validation helps prevent accidental entries, but it is not a replacement for reviewing pasted or imported data; pasted content can bypass some expected controls. Consider adding a separate review column for records that need confirmation, especially when multiple people contribute.
Before sharing or using the workbook for decisions, scan for blanks in required fields, duplicates, unexpected formats, and values outside plausible ranges. Sort or filter one column at a time, and preserve a copy of the original file before making broad corrections. If the data will be maintained regularly by several users, establish conventions for dates, identifiers, units, and allowed labels so that each contributor enters information in the same way.
Frequently Asked Questions
How do I enter a value in an Excel cell?
Select the cell, type the value, and press Enter. Use Tab instead if you want to confirm the entry and move to the cell on its right.
Why does Excel remove the zero at the start of a number?
Excel treats entries made in General format as numbers, and numbers do not preserve leading zeros. Format the cell as Text before entering the code, or prefix a one-off entry with an apostrophe.
What is the difference between a value and a formula in Excel?
A value is the data stored or calculated for a cell. A formula is an instruction, usually beginning with an equals sign, that calculates a result. A formula cell can therefore have a displayed value that differs from the formula shown in the formula bar.
How can I stop people entering inconsistent values?
Use Data > Data Validation to limit entries, such as by making a dropdown list. Pair that control with clear headings and instructions, and review data that has been pasted or imported.
How do I convert numbers stored as text?
First confirm that the cells represent quantities rather than identifiers. Then use the cell warning’s conversion option when available, re-import with the right data type, or use VALUE for text Excel recognizes as a number. Check the resulting values before using them in calculations.
Related
- Excel Attendance Format: A Clear Monthly Attendance Tracker
- Excel Attendance File to Print: Set Up and Print It
- Excel Timesheet Format: Build a Reliable Weekly Sheet
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Keep Duplicate Values in Excel Without Losing DataTo keep repeated entries in Excel, do not run Data > Remove Duplicates on the data you need…
- Excel Keyboard Shortcut to Insert a Row or LineIn Excel for Microsoft 365 on Windows, select a row and press Ctrl+Shift+= to insert a worksheet row…
- Google Sheets IF Statement With Text: Examples and TipsYes. In Google Sheets, an IF statement can test text and return text: use =IF(A2="Paid","Complete","Pending") to show Complete…
- Rate Analysis Excel Sheet: Build and Check Unit RatesA rate analysis Excel sheet breaks the cost of one unit of work into materials, labour, equipment, overhead,…
- How to Insert a Signature Line in WordIn Word for Microsoft 365 on Windows, click where the signature should go, then choose Insert > Text…
- Can You Sort by Date in Google Sheets? Steps and TipsYes. In Google Sheets in a web browser, select your table and choose Data > Sort range >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.