A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old October 4th, 2004, 08:05 AM
mike walker
external usenet poster
 
Posts: n/a
Default Your entry cannot be used. An integer or decimal number may be required.

If I try to format a cell, (font, alignment, number, etc.)
I get this message: "Your entry cannot be used. An integer
or decimal number may be required." I also get this when I
click on any tab in the Options dialog box from the Tools
menu. I am also getting some weird results from Word when
I try to adjust margins in a document. I will enter a
whole number and the error essage will tell me that it is
not a valid number. Finally, I have noticed that in any
setting (i.e. downloading a file, looking at a file's
properties, looking at the size of a file in File Explorer
it will display a file size greater that the actual file
size, for example a 4.5 MB file will be shown as 45 MB. I
just updated my BIOS prior to loading Windows XP Service
pack 2 from a CD and I noticed this behavior afterwards. I
have a Dell Inspiron 8600 that is just about 1 yr. old.
  #2  
Old October 4th, 2004, 06:08 PM
Myrna Larson
external usenet poster
 
Posts: n/a
Default

Have you asked Dell whether the BIOS upgrade has any problems? I installed
Windows SP2, and don't have this problem.

On Mon, 4 Oct 2004 00:05:35 -0700, "mike walker"
wrote:

If I try to format a cell, (font, alignment, number, etc.)
I get this message: "Your entry cannot be used. An integer
or decimal number may be required." I also get this when I
click on any tab in the Options dialog box from the Tools
menu. I am also getting some weird results from Word when
I try to adjust margins in a document. I will enter a
whole number and the error essage will tell me that it is
not a valid number. Finally, I have noticed that in any
setting (i.e. downloading a file, looking at a file's
properties, looking at the size of a file in File Explorer
it will display a file size greater that the actual file
size, for example a 4.5 MB file will be shown as 45 MB. I
just updated my BIOS prior to loading Windows XP Service
pack 2 from a CD and I noticed this behavior afterwards. I
have a Dell Inspiron 8600 that is just about 1 yr. old.


  #3  
Old October 4th, 2004, 10:28 PM
Debra Dalgleish
external usenet poster
 
Posts: n/a
Default

Do you have any accessibility features turned on? There's something
similar in the following MSKB article:

XL97: Errors When Using Microsoft Active Accessibility Magnifier
http://support.microsoft.com/default.aspx?id=200308

mike walker wrote:
If I try to format a cell, (font, alignment, number, etc.)
I get this message: "Your entry cannot be used. An integer
or decimal number may be required." I also get this when I
click on any tab in the Options dialog box from the Tools
menu. I am also getting some weird results from Word when
I try to adjust margins in a document. I will enter a
whole number and the error essage will tell me that it is
not a valid number. Finally, I have noticed that in any
setting (i.e. downloading a file, looking at a file's
properties, looking at the size of a file in File Explorer
it will display a file size greater that the actual file
size, for example a 4.5 MB file will be shown as 45 MB. I
just updated my BIOS prior to loading Windows XP Service
pack 2 from a CD and I noticed this behavior afterwards. I
have a Dell Inspiron 8600 that is just about 1 yr. old.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

  #4  
Old October 4th, 2004, 10:34 PM
Dave Peterson
external usenet poster
 
Posts: n/a
Default

Just wild guesses...

I'd check to see what the regional settings for the decimal character is--maybe
something bad happened to it (win98 wouldn't let me change it to nothing,
though.)

In win98,
windows start button|settings|control panel|regional settings applet
Number tab|Decimal Symbol

I'm guessing that if you're not seeing the dot (my USA setting), then maybe you
have a decimal in one of your excel dialogs.

If you can fix the windows regional setting, maybe you'll be able to see the
problem in your excel dialogs.

I'd go through Tools|Options and see how many options look like numbers. If
possible, maybe reenter them. (But if you get to see the decimal point, then
maybe it'll become obvious.)






mike walker wrote:

If I try to format a cell, (font, alignment, number, etc.)
I get this message: "Your entry cannot be used. An integer
or decimal number may be required." I also get this when I
click on any tab in the Options dialog box from the Tools
menu. I am also getting some weird results from Word when
I try to adjust margins in a document. I will enter a
whole number and the error essage will tell me that it is
not a valid number. Finally, I have noticed that in any
setting (i.e. downloading a file, looking at a file's
properties, looking at the size of a file in File Explorer
it will display a file size greater that the actual file
size, for example a 4.5 MB file will be shown as 45 MB. I
just updated my BIOS prior to loading Windows XP Service
pack 2 from a CD and I noticed this behavior afterwards. I
have a Dell Inspiron 8600 that is just about 1 yr. old.


--

Dave Peterson

  #5  
Old October 5th, 2004, 06:01 AM
Mike Walker
external usenet poster
 
Posts: n/a
Default

Thanks, That did it.

I also saw the KB article referred to in the other posts
but I did'nt have any accesibility features turned on.
-----Original Message-----
Just wild guesses...

I'd check to see what the regional settings for the

decimal character is--maybe
something bad happened to it (win98 wouldn't let me

change it to nothing,
though.)

In win98,
windows start button|settings|control panel|regional

settings applet
Number tab|Decimal Symbol

I'm guessing that if you're not seeing the dot (my USA

setting), then maybe you
have a decimal in one of your excel dialogs.

If you can fix the windows regional setting, maybe you'll

be able to see the
problem in your excel dialogs.

I'd go through Tools|Options and see how many options

look like numbers. If
possible, maybe reenter them. (But if you get to see the

decimal point, then
maybe it'll become obvious.)






mike walker wrote:

If I try to format a cell, (font, alignment, number,

etc.)
I get this message: "Your entry cannot be used. An

integer
or decimal number may be required." I also get this

when I
click on any tab in the Options dialog box from the

Tools
menu. I am also getting some weird results from Word

when
I try to adjust margins in a document. I will enter a
whole number and the error essage will tell me that it

is
not a valid number. Finally, I have noticed that in any
setting (i.e. downloading a file, looking at a file's
properties, looking at the size of a file in File

Explorer
it will display a file size greater that the actual file
size, for example a 4.5 MB file will be shown as 45 MB.

I
just updated my BIOS prior to loading Windows XP Service
pack 2 from a CD and I noticed this behavior

afterwards. I
have a Dell Inspiron 8600 that is just about 1 yr. old.


--

Dave Peterson

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Decimal Point Added to end of number bug jdyer New Users 1 August 31st, 2004 07:16 AM
How do you remove the decimal point in a number? carter General Discussion 5 August 7th, 2004 04:10 AM
Conversion of excel vba code to access vba filnigeria General Discussion 5 July 15th, 2004 02:23 AM
auto number is skipping by one for each entry sheela Using Forms 2 July 7th, 2004 08:30 PM


All times are GMT +1. The time now is 07:57 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.