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 >
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
Get new features first
Join cg-tower.com Insiders
Was this info helpful?
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
Easy to follow
Didn't enhance my screen
Not enough information
Not enough pictures
Any additional feedback? (Optional)
Thank girlfriend for her feedback!
English (United States) © cg-tower.com 2021