Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 10-24-2013, 07:47 AM
BobBridges's Avatar
BobBridges BobBridges is offline Using the sum function to display number as well as words in a single cell Windows 7 64bit Using the sum function to display number as well as words in a single cell Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

I'm going to differ with Peco on this occasion, for one picky reason: Suppose your sum is 234.501, and you use ROUND(234.501,2)? The answer is then displayed as "234.5", whereas you (I suppose) want "234.50". My solution is to use TEXT(234.501,"0.00"), which turns 234.501 into "234.50".

Now, if this works for you then we can stop there, but it has one drawback: The whole cell cannot be used for further calculation, because it's a character string "Total: 234.50" rather than the value 234.5. There is a way you can have both the "Total:" and the numeric value available for calculation.

Go back to the formatting dialogue for this cell, and select the Custom category. Fill in the following as the custom format string:
Code:
"Total: "0.00
Excel fills in the format just as though you'd typed in a standard number format but preceded by the word "Total: ", and still lets you use that cell for arithmetic calculation. If you don't need to do arithmetic on that cell then you may as well use whichever method is easiest; but this method can be pretty handy on occasion.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Using the sum function to display number as well as words in a single cell How to count multiple values in a single cell, except zero? iuliandonici Excel 1 04-13-2011 09:45 PM
Using the sum function to display number as well as words in a single cell Sum & difference between multiple values in a single cell iuliandonici Excel 4 04-13-2011 09:27 PM
Using the sum function to display number as well as words in a single cell How can I break a single group of words into three sets? Learner7 Excel 1 03-22-2011 02:35 PM
Using the sum function to display number as well as words in a single cell How can I write the following (whole) formula in a single cell? Learner7 Excel 1 07-19-2010 10:06 AM
Pasting multiple photos - one photo per cell in a single oepration mccruise Word 0 04-07-2010 04:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:44 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft