Excel because that cg-tower.com 365 Excel because that cg-tower.com 365 because that Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 because that Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel 2010 Excel 2007 Excel because that Mac 2011 More...Less

cg-tower.com Excel might show ##### in cells once a column isn’t vast enough come show every one of the cell contents. Formulas the return dates and times as an unfavorable values can likewise show as #####.

You are watching: What should you do if you see pound signs (###) instead of values or results of formulas?

To do a column more comprehensive to display cell contents in full, double-click the ideal edge the the tower header, or drag it to the width you want.

*

You can also try the following:

To make the cell components smaller, click Home >

*
next to Alignment, and then check the Shrink to fit crate in the Format Cells dialog box.

*

If numbers have too countless decimal places, click Home > Decrease Decimal.

*

If days are as well long, click Home > arrowhead next to Number Format, and also pick Short Date.

See more: What Do You Call A Ship Steering Wheel To A Ship Called? What Is The Name Of The Wheel On A Ship

*

Correct an unfavorable dates or times

When Excel mirrors ##### since the cell has actually a negative date or time value, make certain that you:

Verify dates and times are optimistic values once you’re utilizing the 1900 date system.


*
*
*

Need much more help?


Expand your skills
Explore Training
Get new features first
Join cg-tower.com Insiders

Was this info helpful?


YesNo
Thank you! Any more feedback? (The an ext you tell us the an ext we deserve to help.)Can you assist us improve? (The an ext you tell united state the much more we deserve to help.)
What impacted your experience?
Resolved my issue
Clear instructions
Easy to follow
No jargon
Pictures helped
Other
Didn't enhance my screen
Incorrect instructions
Too technical
Not enough information
Not enough pictures
Other
Any additional feedback? (Optional)
Submit feedback

Thank girlfriend for her feedback!


×
What's new
cg-tower.com Store
Education
Enterprise
Developer
Company
English (United States) © cg-tower.com 2021