| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Assistance
Hello...I have a formula that contains text and can't seem to format it
correctly...any suggestions will be greatly appreciated: Formula: ="Average Savings = "&"$"&SUM(D15-D21) Displays as: Average Savings = $2746.77285714286 Would like to display as: Average Savings = $2746.77 I thank you in advance for your time! Best Regards, -- Randy Street Rancho Cucamonga, CA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting - further assistance required | Excel Worksheet Functions | |||
| Conditional Formatting Assistance | Excel Discussion (Misc queries) | |||
| Need some assistance | Excel Worksheet Functions | |||
| Need assistance with cell formatting | Excel Worksheet Functions | |||
| Need assistance with cell formatting | Excel Worksheet Functions | |||
Threaded Mode
