R retxx New Member Joined Jan 18, 2005 Messages 10 Dec 20, 2005 #1 on a chart of excel when I try entering numbers into cells they come up as #'s how do I fix it? thanks
on a chart of excel when I try entering numbers into cells they come up as #'s how do I fix it? thanks
XLGibbs Well-known Member Joined Feb 25, 2005 Messages 2,446 Dec 20, 2005 #2 You mean the displayed numbers are the pound sign? Either the cells contents are too wide for the column width, or the font is too big to fit in the cell's size. Otherwise, i am not sure I understand the question.
You mean the displayed numbers are the pound sign? Either the cells contents are too wide for the column width, or the font is too big to fit in the cell's size. Otherwise, i am not sure I understand the question.
R retxx New Member Joined Jan 18, 2005 Messages 10 Dec 20, 2005 #3 they are only single digits that I am entering such as lottery numbers ex; 1 4 6 8 when i enter the last one they change to pound signs.
they are only single digits that I am entering such as lottery numbers ex; 1 4 6 8 when i enter the last one they change to pound signs.
XLGibbs Well-known Member Joined Feb 25, 2005 Messages 2,446 Dec 20, 2005 #4 Whether entered into single cells or in one cell as you mention, i could not duplicate the error... Is this a blank workbook or could there be some code or predetermined cell formats causing the issue? What happens if you type text?
Whether entered into single cells or in one cell as you mention, i could not duplicate the error... Is this a blank workbook or could there be some code or predetermined cell formats causing the issue? What happens if you type text?
R retxx New Member Joined Jan 18, 2005 Messages 10 Dec 20, 2005 #5 ADVERTISEMENT give me your e-mail and I will send you the chart to look at. maybe you can figure it out. I believe it is on calculate sheet.
ADVERTISEMENT give me your e-mail and I will send you the chart to look at. maybe you can figure it out. I believe it is on calculate sheet.
XLGibbs Well-known Member Joined Feb 25, 2005 Messages 2,446 Dec 20, 2005 #6 You can click email under my post, I believe, if not send me a PM rather than clutter up the thread any further.
You can click email under my post, I believe, if not send me a PM rather than clutter up the thread any further.
XLGibbs Well-known Member Joined Feb 25, 2005 Messages 2,446 Dec 20, 2005 #7 For the benefit of others who may encounter such a problem, the cells were formatted as a date, instead of number making the displayed format to large for the cells size. Relatively common error caused by the cell format.
For the benefit of others who may encounter such a problem, the cells were formatted as a date, instead of number making the displayed format to large for the cells size. Relatively common error caused by the cell format.
