| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make last digit always display the same value.
I add a series of prices. Regardless of the last digit in the sum, I want to
make the digit a 9. For example, the calculated sum of prices is $5.00. I want $5.09 displayed. If the sum is $5.87, I want $5.89 displayed. Help, please. ---------------- 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 | |||
| Display entire 19 digit number | Excel Discussion (Misc queries) | |||
| Display a 16 digit number | Excel Discussion (Misc queries) | |||
| Display a digit before or after the decimal point in another cell | Excel Worksheet Functions | |||
| How do you display 16 digit numbers in excel ? (it keeps convert. | Excel Discussion (Misc queries) | |||
| When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) | |||
Threaded Mode
