Your entry cannot be used. An integer or decimal number may be req

J

JLB

I have been trying to format cells and when I do, this message pops up:
"Your entry cannot be used. An integer or decimal number may be required." I
am also having problems with formulas I already had in place. Anytime I try
to change anything in a spread sheet this message pops up. It pops up in a
new spreadsheet or one I already have in place. Any ideas.
 
C

Chip Pearson

It sounds like there is a Data Validation constraint on the cell(s).
Select the cell, choose Validation from the Data menu, and see what
values are allowed You can either conform your entry to the constraint
or you can remove the validation constraint by choosing Any in the
Allow list in the Validation dialog.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]
 
J

JLB

Thanks for the help Chip but it didn't do any good, "ANY" was already
choosen in the allow list. When I right click on a highlighted cell(s) and
click on format, the format box pops up. If I try to click on any of the
tabs they cannot be used message comes up. I have removed and reinstalled
Office 2007 with no changes. If I start a new spread sheet and try to put
boarders around my cells, the program will not let me having the above
message pop up. Basically I cannot use Excell right now. Any other ideas?

Jeff

Chip Pearson said:
It sounds like there is a Data Validation constraint on the cell(s).
Select the cell, choose Validation from the Data menu, and see what
values are allowed You can either conform your entry to the constraint
or you can remove the validation constraint by choosing Any in the
Allow list in the Validation dialog.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]



I have been trying to format cells and when I do, this message pops up:
"Your entry cannot be used. An integer or decimal number may be required." I
am also having problems with formulas I already had in place. Anytime I try
to change anything in a spread sheet this message pops up. It pops up in a
new spreadsheet or one I already have in place. Any ideas.
.
 
S

sankar e

please change your regionol and language settings.



JLB wrote:

Your entry cannot be used. An integer or decimal number may be req
12-Mar-10

I have been trying to format cells and when I do, this message pops up:
"Your entry cannot be used. An integer or decimal number may be required." I
am also having problems with formulas I already had in place. Anytime I try
to change anything in a spread sheet this message pops up. It pops up in a
new spreadsheet or one I already have in place. Any ideas.

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
BizTalk Configure and Send SMTP Mail Based on Message Within an Orchestration
http://www.eggheadcafe.com/tutorial...1-a2f309a021c2/biztalk-configure-and-sen.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top