Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default displays "####" when 1-digit number typed

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)?
  #2   Report Post  
Posted to microsoft.public.excel.misc
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)?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default displays "####" when 1-digit number typed

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

On Apr 12, 6:10*pm, 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)?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Speech recog'n msg in Excel displays "No Signal". EarlyBirdie Excel Discussion (Misc queries) 2 March 26th 08 01:13 PM
"." on numeric keypad displays "," TOMMIETOM Excel Discussion (Misc queries) 11 March 14th 07 07:34 AM
Why does the word typed "true" automatically turn to ALL CAPS? sunil New Users to Excel 2 October 31st 06 07:41 AM
SUM Calculations Returns #VALUE but displays correct total with "Insert Function"=fx Yo! Excel Worksheet Functions 2 September 7th 06 08:22 PM
Print in Excel displays "save as" screen and never prints. QA GUY Excel Discussion (Misc queries) 0 July 6th 06 09:28 PM


All times are GMT +1. The time now is 03:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"