If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
####### 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
|
|||
|
|||
####### 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
|
|||
|
|||
####### 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
|
|||
|
|||
####### 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
|
|||
|
|||
####### 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
|
|||
|
|||
####### 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
|
|||
|
|||
####### 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
|
|||
|
|||
####### 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 |
Thread Tools | |
Display Modes | |
|
|