| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format option for decimal. e.g., entering 531 results in 5.31
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format cell based on results of vlookup function | Excel Worksheet Functions | |||
| Change the format of my footer {date} option? | Excel Discussion (Misc queries) | |||
| entering numbers to display a time format | Excel Discussion (Misc queries) | |||
| Dates in 2005 format cells are not entering correctly. | Excel Worksheet Functions | |||
| Help Q: Entering 7 p time format, does not convert to 19:00 | Excel Discussion (Misc queries) | |||
Threaded Mode
