How to set "fixed decimal" in 2007
 

I have recently been upgraded to 2007 (under protest!) and I can no longer
find the "fixed decimal" feature that enables you to not have to enter the
decimal when entering number values. For example, with the fixed decimal
feature I can enter 525 and it recognizes it as 5.25. If I wanted 525.00 I'd
enter 52500.

On the help all I can find is a function that reads off of another column.
I want to just be able to set the value to fixed but I also want to be able
to change it back on occasion. Does 2007 enable this?

Is anybody @ MS talking about classic menus for 2007? No long-time users I
know like these menus, they're very cumbersome.

Thanks -

mm

How to set "fixed decimal" in 2007
 

Office button, Advanced tab, 2nd checkbox!
Bob Umlas
Excel MVP

"smartgal" wrote in message
...
I have recently been upgraded to 2007 (under protest!) and I can no longer
find the "fixed decimal" feature that enables you to not have to enter the
decimal when entering number values. For example, with the fixed decimal
feature I can enter 525 and it recognizes it as 5.25. If I wanted 525.00
I'd
enter 52500.

On the help all I can find is a function that reads off of another column.
I want to just be able to set the value to fixed but I also want to be
able
to change it back on occasion. Does 2007 enable this?

Is anybody @ MS talking about classic menus for 2007? No long-time users
I
know like these menus, they're very cumbersome.

Thanks -

mm

How to set "fixed decimal" in 2007
 

Office Button, excel Options, Editing Options, Automatically insert a
decimal point.

In the future you may want to try pressing F1, and look up the "missing
item".

smartgal wrote:

I have recently been upgraded to 2007 (under protest!) and I can no longer
find the "fixed decimal" feature that enables you to not have to enter the
decimal when entering number values. For example, with the fixed decimal
feature I can enter 525 and it recognizes it as 5.25. If I wanted 525.00 I'd
enter 52500.

On the help all I can find is a function that reads off of another column.
I want to just be able to set the value to fixed but I also want to be able
to change it back on occasion. Does 2007 enable this?

Is anybody @ MS talking about classic menus for 2007? No long-time users I
know like these menus, they're very cumbersome.

Thanks -

mm

How to set "fixed decimal" in 2007
 

Sorry to be such a dunce but what / where is the Office button?

"Bob Umlas" wrote:

Office button, Advanced tab, 2nd checkbox!
Bob Umlas
Excel MVP

"smartgal" wrote in message
...
I have recently been upgraded to 2007 (under protest!) and I can no longer
find the "fixed decimal" feature that enables you to not have to enter the
decimal when entering number values. For example, with the fixed decimal
feature I can enter 525 and it recognizes it as 5.25. If I wanted 525.00
I'd
enter 52500.

On the help all I can find is a function that reads off of another column.
I want to just be able to set the value to fixed but I also want to be
able
to change it back on occasion. Does 2007 enable this?

Is anybody @ MS talking about classic menus for 2007? No long-time users
I
know like these menus, they're very cumbersome.

Thanks -

mm

How to set "fixed decimal" in 2007
 

Never mind, I found it. Thanks so much!!

"Bob Umlas" wrote:

Office button, Advanced tab, 2nd checkbox!
Bob Umlas
Excel MVP

"smartgal" wrote in message
...
I have recently been upgraded to 2007 (under protest!) and I can no longer
find the "fixed decimal" feature that enables you to not have to enter the
decimal when entering number values. For example, with the fixed decimal
feature I can enter 525 and it recognizes it as 5.25. If I wanted 525.00
I'd
enter 52500.

On the help all I can find is a function that reads off of another column.
I want to just be able to set the value to fixed but I also want to be
able
to change it back on occasion. Does 2007 enable this?

Is anybody @ MS talking about classic menus for 2007? No long-time users
I
know like these menus, they're very cumbersome.

Thanks -

mm