####### 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

####### 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

####### 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

####### 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

####### 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

####### 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

####### 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

####### 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