View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
pdberger pdberger is offline
external usenet poster
 
Posts: 258
Default displays "####" when 1-digit number typed

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?

"meanmommy" wrote:

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)?