Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Speech recog'n msg in Excel displays "No Signal". | Excel Discussion (Misc queries) | |||
"." on numeric keypad displays "," | Excel Discussion (Misc queries) | |||
Why does the word typed "true" automatically turn to ALL CAPS? | New Users to Excel | |||
SUM Calculations Returns #VALUE but displays correct total with "Insert Function"=fx | Excel Worksheet Functions | |||
Print in Excel displays "save as" screen and never prints. | Excel Discussion (Misc queries) |