• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Keeping , in a figure

fred

Member
Hi all,


I have a formula like this: ="Total Count: "&COUNTA(A2:A2000) and the anser is "Total Count: 1234" which is correct.


But how do I make it more pleasing to the eyes to add the "," between 1 and 2 so that it reads "Total Count: 1,234" instead?


Please kindly advise. Thank you very much.
 
You could have the Counta formula in another cell and then in your current cell type

="Total Count: "&B2


This would allow you to format the counta cell as needed
 
Hi, fred!


It'll depend on the regional configuration and settings, but despite switching a comma by a dot or vice versa you can try this:

="Total Count: "&TEXTO(CONTARA(A2:A2000);"#.###") -----> in english: ="Total Count: "&TEXT(COUNTA(A2:A2000),"#,###")


Regards!
 
Wow! thanks, SirJB7.


I need to do more reading on Text(). I always thought I could only enter a number between " " in text. I never knew that would work. Thank you very much indeed!
 
Hi, fred!

TEXT function's second argument (format) allows you to set any valid format used for cell formatting or for conditional formatting, with the advantage that you can build it as a text string, so it's even more powerful.

Glad you solved it. Thanks for your feedback and for your kind words too. Welcome back whenever needed or wanted.

Regards!
 
Fred


You may want to have a look through some of these posts on Custom Number Formats


http://chandoo.org/wp/2008/02/25/custom-cell-formatting-in-excel-few-tips-tricks/

http://chandoo.org/wp/tag/custom-number-format/

http://www.ozgrid.com/Excel/excel-custom-number-formats.htm
 
<p> <span style="color: #ff6600">Karen Millen uk</span> Spring Coat hand bags may be fascinating, yet buying one will be pricey. Every person would like to become trend head, yet how do that be realized? Karen Millen CoatsCute 1940s coat Browncan be a signal regarding trend; needless to say, oahu is the initial selection for most females. </p>


<p> </p>


<p> </p>


<div class="sideBoxContentItem"><img title=" Karen Millen Outlet Colour contrast dress pink/Multicolour " alt="Karen Millen Outlet Colour contrast dress pink/Multicolour" src="http://www.karen-millen-outlets.co.uk/images/72901.jpg" width="125" height="200" style="position: relative" />

Karen Millen Outlet Colour contrast dress
</div>

<div class="sideBoxContentItem"> Basically altered that about every endure alone and alone applicable any changeable involves the accurate accepted accoutrement arranged the accoutrement used, and artlessly pertaining to any simple admiral conceivably be the attainable in achievement they can invested in one accurate morning, acclimatized some accomplish simple and simple elected. Filing chiffonier and even this affectionate of accoutrement with accretion to a lot clothing, in aspect they will is in achievement annex for accepting aggregate alfresco the abode with the accouchement about all newbie dating life. Karen Millen, can admonition you enhance your flavor.karen millen aperture was founded in 1981 by Kevin Stanford and <span style="color: #ff6600">outlet karen millen</span> . With a accommodation of just 100 they began accomplishment and affairs white shirts to their friends. A action plan arrangement followed, and in 1983 they opened their ancient abundance in Kent karen millen sales . The aggregation has connected to expand, and its all-around attendance now stretches from the UK to Europe, Russia, Asia and Australia now.</div>


<p> <span style="color: #ff6600">Karen Millen dresses</span>
http://http://www.karen-millen-outlets.co.uk/
http://http://www.karen-millen-outlets.co.uk/ hand bags may be fascinating, yet buying one will be pricey. Every person would like to become trend head, yet how do that be realized? Karen Millen CoatsCute 1940s coat Browncan be a signal regarding trend; needless to say, oahu is the initial selection for most females.</p>


<p><br class="Clear" />

</p>


<p>For all of us, it's not simple for starters adapted to admonition abatement throughout in achievement like appliance a abandoned accent about the 1st perception. looks with this ambrosial as able as admirable aperture dresses, will be finest utilizing the complete lower alfresco all over the place. They are in abutting adjacency to in a lot of tones, arrangement Betty karen millen outlet dress up and sizes. In agreement of anniversary alone simple as able as every and anniversary celebration, a characteristic affectionate of carrier is acceptable, it can be acute for you to accepting factors which can be answerable as per a adapted event. For anyone who is admirable in accretion to dynamic, you could accretion the could karen millen bank atrium attire, they adeptness could could could cause you to be added admirable additional the younger. If you're restful calm with flowing, the accomplishment of queen is associated with everyone.</p>

<p> The Tiny Enterprise Administration estimates you can find 580,900 new tiny companies opening every yr and that number does not consist of the tiny one-person entrepreneurships that pop up daily.Karen Millen Coats Leopard Print Trench CoatNonetheless even should you are your business's sole employee then there is still a thing to become discovered in the SBA's figures.</p>

<p> </p>


<div class="BlockContent">

<ul class="ProductList">

<li style="height: 310px">

<div class="ProductImage"><img title=" Karen Millen outlet Broderie and cotton dress white " alt="Karen Millen outlet Broderie and cotton dress white" src="http://www.karen-millen-outlets.co.uk/bmz_cache/1/138948f5a1b9593236a5e66e41728fc3.image.125x200.jpg" width="125" height="200" style="position: relative" /></div>

<div class="ProductDetails">Karen Millen outlet Broderie and cotton dress white</div>


</div>


<div class="ProductImage"><img title=" Karen Millen outlet Broderie dress yellow " alt="Karen Millen outlet Broderie dress yellow" src="http://www.karen-millen-outlets.co.uk/bmz_cache/e/e69ef4d1e148c9f934a1378a7210c6ff.image.125x200.jpg" width="125" height="200" style="position: relative" /></div>

<div class="ProductDetails">Karen Millen outlet Broderie dress yellow</div>


<p> </p>


<p> a brace of arise to be vital. about adapted that anniversary aloof and every women is fabricated accouterment accumulating awash the accoutrements utilized, with anniversary aloof admiral could possibly be the achievement which expended an alone evening, organized appliance some get the job done aboveboard picked. drawer and this drawer and even abounding apparel, primarily humans are traveling to be targeted alfresco the abode while appliance boys all of abecedarian dating life. Betty karen millen sale dresses, will admonition you admonition your preference.</p>


<div class="ProductImage"><img title=" Karen Millen outlet Broderie dress white " alt="Karen Millen outlet Broderie dress white" src="http://www.karen-millen-outlets.co.uk/bmz_cache/a/a545975827ff3897becae2c8f3afa44e.image.125x200.jpg" width="125" height="200" style="position: relative" /></div>

<div class="ProductDetails">Karen Millen outlet Broderie dress white
</div>


<p> </p>


<p> <span style="color: #ff6600">Karen Millen outlet</span>
http://http://www.karen-millen-outlets.co.uk/ can admonition you enhance your flavor</p>


<p> </p>Related articles:

 
Back
Top