error displaying large numbers

  • Thread starter Thread starter donkermazoid
  • Start date Start date
D

donkermazoid

I formatted a cell as currency and tried to input a number larger than
1000 and the cell displays #######. Anyone know why this is and how to
fix it?
 
Hi,

Resize column width. Either drag cell to fit or select column the
format > column > autofit.

VBA Noo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell Input ~ Display 2
Currency autofit 5
How to display the value in different format? 7
How to set 2 currency format in 1 cell?? 2
Formatting Cell that Contains If/Then Formula 5
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Excel Need Countifs Formula Help 0
Assigning a currency symbol on the fly 13

Back
Top