Need Numbers to Concatenate to Number Format, Not Text Format

[DJH]

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!

[dredwolf]

If the data is numeric to start with, don't concatenate,add instead
ie - instead of &".5" use +.5 (or, for the purists, +0.5)

[dredwolf]

BTW, Screen shots are almost impossible to work with, if you want actual formulas, upload a sample workbook

[FDibbins]

If you must & the .5, then times the end result with 1, or add 0

Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you Also, not all members can upload picture files (Company firewalls and stuff)