View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
smartgal smartgal is offline
external usenet poster
 
Posts: 84
Default 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