David; Wouldn't it be nice if you didn't have to go through that process to
start that format method, instead of selecting it as an option from the
"format cell" selections in the drop down ribbon? When you change the format
the way you instruct, you also have to remember to change it back when you
are finished.

"David Biddulph" wrote:

"Wisteria" wrote in message
...
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.

You may wish to look at Tools/ Option/ Edit
Fixed decimal places

But remember that this changes the value rather than changing the display
format.
--
David Biddulph