=B3 then press Enter. This formula references the value directly. If the content appears as text or zeros, check the cell formatting via the Number dropdown on the Home tab to ensure it is set to General or Number rather than Text.
Basic Formula Reference
The most direct method to show the value of another cell is using an equality formula. When you enter =B3 into any other cell, Excel retrieves the underlying value stored in B3. This approach works regardless of whether B3 contains a static number, a calculated result, or a date. The displayed value will update automatically if the source cell changes.
- Select the destination cell where you want the number to appear.
- Type the equals sign followed by the cell reference:
=B3. - Press the Enter key to confirm the entry.
This technique creates a dynamic link. If you delete the content of B3, the destination cell will become empty or zero depending on its format. It is important to note that this method copies the value but not the formatting. If B3 is bold or red, your new cell will remain default styled unless you manually adjust it.
Troubleshooting Display Issues
Sometimes users believe the number is not showing up, when in reality it is hidden by formatting or data type issues. A common scenario involves numbers stored as text. If cell B3 contains a number formatted as text, copying it with =B3 might result in a green triangle warning or left-aligned text in the destination.
To fix this, you can convert the text to a number. Select cell B3, click the yellow exclamation icon that appears next to the cell, and choose "Convert to Number." Alternatively, use the VALUE function in your formula: =VALUE(B3). This forces Excel to interpret the content as a numeric value rather than a string.
Another frequent issue is custom number formatting. If B3 has a format code like 0;-0;;@, negative numbers might appear blank. Check the Format Cells dialog (Ctrl+1) under the Number tab. Ensure the category is set to General, Number, or Accounting to guarantee visibility. You can also use the TEXT function if you need specific decimal places, such as =TEXT(B3,"0.00").
Using Paste Special for Static Values
If you do not want a live link to B3, you can paste the value only. This breaks the connection and leaves a static copy. Right-click the source cell B3 and select Copy. Navigate to the destination cell, right-click again, and choose Paste Special. In the dialog box, select "Values" and click OK. This is useful for creating snapshots of data at a specific point in time.
For more complex scenarios involving conditional displays, consider checking out How to Copy Values Only if Another Column Says 'Completed' in Microsoft Excel. This guide explains how to automate value transfers based on status flags, which complements simple cell referencing.
Handling Blank or Error States
If cell B3 is empty, =B3 will return a zero if the destination is formatted as a number. To avoid this, wrap the reference in an IF statement: =IF(B3="","",B3). This checks if B3 is blank and returns an empty string instead of zero. This keeps the interface clean when data is missing.
Errors in B3, such as #DIV/0! or #N/A, will propagate through the formula. Use IFERROR to handle these gracefully: =IFERROR(B3,"No Data"). This ensures that invalid calculations do not clutter your worksheet with error codes.
Related Considerations
When working with large datasets, ensure that your formulas are not inadvertently creating circular references. If B3 depends on the cell containing =B3, Excel will warn you. Also, be aware that some numbers may open as hyperlinks automatically. For guidance on preventing this behavior, refer to How to Stop Numbers from Automatically Opening Hyperlinks in Excel.
Frequently Asked Questions
Why does my cell show 0 instead of the actual number?
This usually happens when the source cell is formatted as Text but contains numeric characters, or when the source is truly blank. Check the source cell's format and convert it to Number if necessary. If the source is blank, the zero is the default numeric representation of an empty cell.
Can I copy the formatting along with the number?
No, standard formulas like =B3 only copy the value. To copy both value and formatting, use Paste Special > All Using Source Theme or Ctrl+C followed by Alt+E+S+E for values only, then manually apply formatting. There is no single formula flag for this.
What if B3 contains a date and I want just the number?
Dates in Excel are stored as serial numbers. =B3 will show the serial number (e.g., 44562) if formatted as General. To see the date, change the format back to Date. To extract just the day, month, or year, use functions like DAY(B3), MONTH(B3), or YEAR(B3).
How do I prevent leading zeros from disappearing?
Excel strips leading zeros from numbers by default. To keep them, format the cell as Text before entering the data, or prefix the number with an apostrophe ('007). If you already have numbers, use the TEXT function: =TEXT(B3,"000") to force three digits.
Does changing the font size affect the displayed number?
Yes, changing the font size in the destination cell affects readability but not the underlying value. The formula =B3 always pulls the exact numeric value from B3, regardless of how large or small the text appears in the target cell.