+ Reply to Thread
Results 1 to 2 of 2

Restoring decimal place to cells with text & sum?

  1. 06-30-2015, 04:49 PM #1
    Emma Frost
    Emma Frost is offline
    Registered User
    Join Date
    03-31-2015
    Location
    United Kingdom
    MS-Off Ver
    Mac 2011
    Posts
    8

    Restoring decimal place to cells with text & sum?

    I have a field that sums and has text in it, but I can't get the comma for thousands to reappear because there is text in it.

    Please Login or Register  to view this content.
    It's displaying as 102300 words and I want it to display as 102,300 words

    Any help?

    Thanks
    Reply With QuoteRegister To Reply
  2. 06-30-2015, 04:56 PM #2
    nigelbloomy
    nigelbloomy is offline
    Valued Forum Contributor nigelbloomy's Avatar
    Join Date
    11-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1,011

    Re: Restoring decimal place to cells with text & sum?

    Does this help?
    Please Login or Register  to view this content.
    Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.

    <---Click * Add Reputation for all helpful comments. It's like giving a smile.
    Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Display only 1 decimal place but when combined with text
    By Leonthefixer in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-23-2015, 06:58 AM
  2. How can I locate all cells with the same value and place specific text in adjacent cells
    By taylormade in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-13-2014, 08:13 AM
  3. Decimal place Help
    By cadk73 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-26-2012, 03:56 PM
  4. Excel 2007 : '=if' statement - matching 2 cells to a decimal place
    By dancing-shadow in forum Excel General
    Replies: 2
    Last Post: 02-04-2011, 09:33 AM
  5. [SOLVED] Converting 2-place decimal value to floating point decimal number with leading zero
    By Kermit Piper in forum Excel General
    Replies: 3
    Last Post: 03-18-2006, 02:25 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1