How to set "fixed decimal" in 2007

S

smartgal

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
 
B

Bob I

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".
 

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