entering numbers

retxx

New Member
Joined
Jan 18, 2005
Messages
10
on a chart of excel when I try entering numbers into cells they come up as #'s how do I fix it? thanks
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

XLGibbs

Well-known Member
Joined
Feb 25, 2005
Messages
2,446
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.
 

retxx

New Member
Joined
Jan 18, 2005
Messages
10
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
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?
 

retxx

New Member
Joined
Jan 18, 2005
Messages
10

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

Watch MrExcel Video

Forum statistics

Threads
1,119,271
Messages
5,577,124
Members
412,769
Latest member
VK12345
Top