Auto decrease in digit..

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mahesh - 08 Jun 2006 09:54 GMT

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 to this Message

Norman Jones - 08 Jun 2006 10:06 GMT

Hi Mahesh,

Try:

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

---
Regards,
Norman

> Dear Sirs / Madam,
>
[quoted text clipped - 3 lines]
> Regards,
> Mahesh

Reply to this Message

dbahooker@hotmail.com - 08 Jun 2006 17:12 GMT

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

> Dear Sirs / Madam,
>
[quoted text clipped - 3 lines]
> Regards,
> Mahesh

Reply to this Message

greaseman - 29 Jun 2006 16:56 GMT

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.

Signature

greaseman

Reply to this Message