+ Reply to Thread
Results 1 to 3 of 3

Converting text number to a number in a formula...

  1. #1
    Registered User
    Join Date
    03-22-2016
    Location
    Georgia, US
    MS-Off Ver
    2010
    Posts
    2

    Converting text number to a number in a formula...

    I have a sheet with that calculates tank coverage based off info that is entered.

    From this calculation I have a line that says "Your tank coverage is X sq. ft." The issue I am having is that the X shows up as a text based number (66700) and I would like it to show up as a number (66,700). I tried the DOLLAR function and it formatted it properly except that I do not need the $. Cannot find another function that allows for a similar format without the $...

    As you can see in the photo below, the user enters tank size in column C. Based off info in the above rows, it calculates the coverage in Column D. To simplify numbers I did the ROUNDUP function in Column E. Then I converted to sq. ft. by multiplying E * 1000, column F. The amount in F gets populated over to B27... (I'm sure there was a simpler way to do this but it's the only way i knew! )

    Excel 1.JPG

    This photo shows my formulas.
    Excel 2.JPG

    Let me know if have the value of 66,700 is possible for cell B27...

    Thanks,
    Tom

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829

    Re: Converting text number to a number in a formula...

    Use the =TEXT() function inside of your CONCATENATE() function: https://support.office.com/en-us/art...8-93d29371225c
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    03-22-2016
    Location
    Georgia, US
    MS-Off Ver
    2010
    Posts
    2

    Re: Converting text number to a number in a formula...

    Worked like a charm! Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] CONVERTING NUMBER TO TEXT
    By RAJEEV CHADHA in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-14-2017, 07:40 AM
  2. [SOLVED] Converting a number to text
    By Fishenguy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-23-2012, 11:52 AM
  3. Replies: 16
    Last Post: 04-20-2010, 01:27 PM
  4. converting number to text
    By oddcarout in forum Excel General
    Replies: 1
    Last Post: 05-29-2008, 05:30 PM
  5. what formula converting number to text in english or hindi in exl
    By satyavan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-17-2006, 02:45 AM
  6. converting text to number
    By Anat in forum Excel General
    Replies: 5
    Last Post: 02-23-2006, 04:30 PM
  7. Converting Text to Number
    By Andrew Bartholomew in forum Excel General
    Replies: 1
    Last Post: 03-24-2005, 11:06 PM
  8. [SOLVED] Converting text to a number
    By Helen Black in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-19-2005, 12:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1