displays "####" when 1-digit number typed

  • Thread starter Thread starter meanmommy
  • Start date Start date
M

meanmommy

I've used MSExcel for years. Why, all-of-a-sudden am I getting the max-out
sign for a 1-digit number in a cell (Excel 2007)?
 
I was able to recreate your problem by formatting a cell to about 10 digits,
and then setting the width too narrow. Have you checked your format?
 
Perhaps the cell is formatted as a date, and your column is too narrow
to display it. Set the format to General.

Hope this helps.

Pete
 

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

Back
Top