Decimal format feature in Excel-entering e.g. 531 enters as 5.31

W

Wisteria

Have the option in the format cell list of a automatic decimal placement so
that when you enter e.g.-531 the result is 5.31.

----------------
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/com...120f6486d582&dg=microsoft.public.officeupdate
 
G

garfield-n-odie [MVP]

Your suggestion is unnecessary, because such a feature already
exists in Excel.
 
W

Wisteria

I do not want to go through the hassle of going through "Tools"-"Options"
etc. If a 2 place decimal could be in the drop down box of formats like the
"$"; and the "," options as this is then the default format. I would prefer
to be able to select "only" the columns or rows that I want to apply that
format to from the "format cells" drop down box.
 
Top