PC Review


Reply
Thread Tools Rate Thread

Auto decrease in digit..

 
 
Mahesh
Guest
Posts: n/a
 
      8th Jun 2006

Dear Sirs / Madam,

I have problem in excel 2003 . while i type 10000 it automatically shows 100
& while i type 100 it shows 1 . Please let me know the sollution

Regards,
Mahesh


 
Reply With Quote
 
 
 
 
Norman Jones
Guest
Posts: n/a
 
      8th Jun 2006
Hi Mahesh,

Try:

Tools | Options | General | deselect the 'Fixed Decimal' option.


---
Regards,
Norman


"Mahesh" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> Dear Sirs / Madam,
>
> I have problem in excel 2003 . while i type 10000 it automatically shows
> 100 & while i type 100 it shows 1 . Please let me know the sollution
>
> Regards,
> Mahesh
>



 
Reply With Quote
 
dbahooker@hotmail.com
Guest
Posts: n/a
 
      8th Jun 2006
wow. that is a pretty cool feature.

now how can i enforce that they can only enter a fixed integer?

if they enter 100.12 in an integer field it bitches and moans??

-aaron




Mahesh wrote:
> Dear Sirs / Madam,
>
> I have problem in excel 2003 . while i type 10000 it automatically shows 100
> & while i type 100 it shows 1 . Please let me know the sollution
>
> Regards,
> Mahesh


 
Reply With Quote
 
greaseman
Guest
Posts: n/a
 
      29th Jun 2006

Hey, little Aaron,

Since you claim in both this forum and in many other forums to be such
a woohoo genius and make out that others are four-letter words of your
own choice, figure it out yourself.

Maybe that'll give you something to do while you moan and groan about
Excel and about how Microsoft canned you.


--
greaseman
------------------------------------------------------------------------
greaseman's Profile: http://www.excelforum.com/member.php...o&userid=28808
View this thread: http://www.excelforum.com/showthread...hreadid=549887

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
4 digit auto number =?Utf-8?B?cmFq?= Microsoft Access Database Table Design 3 21st Jan 2006 08:54 AM
Excel: let me a color a single digit in a multi-digit cell =?Utf-8?B?UGh5bGxpcw==?= Microsoft Frontpage 6 13th Nov 2005 11:13 PM
Auto fill keeps adding 1 digit or 1 cell Ricardo Microsoft Excel Misc 2 12th Jul 2004 08:50 PM
How to auto append word to only digit input data? crapit Microsoft Excel Discussion 1 10th Jan 2004 07:39 PM
Change 2 digit suffix in 14 digit number in a column of numbers. Brad H. Microsoft Excel Worksheet Functions 1 4th Sep 2003 04:35 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:52 PM.