If you click on TOOLS, select OPTIONS and then click the EDIT tab, there's a
checkbox titled FIXED DECIMAL PLACES which does exactly what your suggestion
asks for. It's been around for the last couple of release if I remember
correctly.
--
Kevin Backmann


"Wisteria" wrote:

Have an option of selecting a "format cell" decimal feature that allows
automatic 2 place value setting. E.g. entering 531 results in 5.31, or $5.31
when you have also selected the cells to be "currency" formated.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc