Results 1 to 4 of 4

Need Numbers to Concatenate to Number Format, Not Text Format

Threaded View

  1. #1
    Registered User
    Join Date
    03-06-2012
    Location
    Spring, TX
    MS-Off Ver
    Excel 2007
    Posts
    9

    Need Numbers to Concatenate to Number Format, Not Text Format

    Hi all,

    I'm trying to convert some data from MLS to make it easier to work with statistically. The raw data regarding Bath count downloads from MLS in 2 columns; 1 column for Full Baths & 1 column for Half Baths (see Raw Data.jpg). I want to concatenate the baths to one column and, if there is a 1/2 bath, tack ".5" to the end of the full bath count.

    The problem with my formula is that if it concatenates the ".5" to the full bath count number, it converts the format to text (see Current Formula.jpg). I know I can go through later and convert it back to number format but is there a formula I could use that would keep it in number format?

    Thanks for any help!
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Converting a range of numbers stored as text to number format w/o looping
    By Excel_vba in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-23-2013, 04:40 AM
  2. Convert date and time in serial number format to text format
    By nda13112 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-11-2013, 02:45 PM
  3. Changing numbers from text format to number format
    By garden_gnome in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-09-2012, 12:48 PM
  4. [SOLVED] Format numbers / Concatenate
    By dbizek in forum Excel General
    Replies: 4
    Last Post: 06-23-2005, 02:05 PM
  5. Convert numbers from text format to number format
    By merlin68 in forum Excel General
    Replies: 4
    Last Post: 04-12-2005, 09:06 AM

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