| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
####### appearing on top of numbers
Hi all. I am completely new to Excel. I was formating a selected range to
include a floating dollar sign and when I completed, the numbers in the first and last cell on the first row are covered by ######. When I double click the cell, the number appears will not remain. Help. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
####### appearing on top of numbers
##### means your column isn't wide enough to show the data in there..
-- JoAnn Paules MVP Microsoft [Publisher] ~~~~~ How to ask a question http://support.microsoft.com/KB/555375 "LKG" wrote in message ... Hi all. I am completely new to Excel. I was formating a selected range to include a floating dollar sign and when I completed, the numbers in the first and last cell on the first row are covered by ######. When I double click the cell, the number appears will not remain. Help. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
####### appearing on top of numbers
normally when the cross hatching is in place of a number it is because your
column is not wide enough to fit the number. Try widening the column until your number appears. (Sometimes if you have a number in place and then give it formatting or bold it or change a font it suddenly becomes too large for the cell, so just widen the cell.) "LKG" wrote: Hi all. I am completely new to Excel. I was formating a selected range to include a floating dollar sign and when I completed, the numbers in the first and last cell on the first row are covered by ######. When I double click the cell, the number appears will not remain. Help. Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
####### appearing on top of numbers
The column is too narrow, make it wider by double clicking on the column
heading between the letter of the column and the next column (you get a souble arrow when you are in the correct place) -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "LKG" wrote: Hi all. I am completely new to Excel. I was formating a selected range to include a floating dollar sign and when I completed, the numbers in the first and last cell on the first row are covered by ######. When I double click the cell, the number appears will not remain. Help. Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
####### appearing on top of numbers
Thanks for the help!! "JoAnn Paules" wrote: ##### means your column isn't wide enough to show the data in there.. -- JoAnn Paules MVP Microsoft [Publisher] ~~~~~ How to ask a question http://support.microsoft.com/KB/555375 "LKG" wrote in message ... Hi all. I am completely new to Excel. I was formating a selected range to include a floating dollar sign and when I completed, the numbers in the first and last cell on the first row are covered by ######. When I double click the cell, the number appears will not remain. Help. Thanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
####### appearing on top of numbers
Thank you sooooo much!!!!
"john" wrote: The column is too narrow, make it wider by double clicking on the column heading between the letter of the column and the next column (you get a souble arrow when you are in the correct place) -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "LKG" wrote: Hi all. I am completely new to Excel. I was formating a selected range to include a floating dollar sign and when I completed, the numbers in the first and last cell on the first row are covered by ######. When I double click the cell, the number appears will not remain. Help. Thanks |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
####### appearing on top of numbers
Thank you for the help!!!
"LKG" wrote: Hi all. I am completely new to Excel. I was formating a selected range to include a floating dollar sign and when I completed, the numbers in the first and last cell on the first row are covered by ######. When I double click the cell, the number appears will not remain. Help. Thanks |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
####### appearing on top of numbers
Make the column wider by dragging the column header to the right.
Or select the column header and FormatColumnAutofit selection. Gord Dibben MS Excel MVP On Thu, 22 Feb 2007 10:16:37 -0800, LKG wrote: Hi all. I am completely new to Excel. I was formating a selected range to include a floating dollar sign and when I completed, the numbers in the first and last cell on the first row are covered by ######. When I double click the cell, the number appears will not remain. Help. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In excel 2003, the negative numbers not appearing with brackets | New Users to Excel | |||
| Help - Separating numbers appearing on the right of a text string | Excel Worksheet Functions | |||
| Worksheet Not Appearing | Excel Discussion (Misc queries) | |||
| how do I stop this appearing.......#DIV/0! | New Users to Excel | |||
| vlookup for a value appearing more than once | Excel Worksheet Functions | |||
Linear Mode
