Concatenate formula

**twofootgiant** · 09-30-2009, 07:37 AM

Hi Guys

I am using a concatenate formula.

included within the string of cells that I am combining there is one which says "3.00mm". The formula displays this as 3mm cutting off the decimals, how do I make it display as 3.00mm?

Thanks

**zbor** · 09-30-2009, 07:38 AM

Foramt cells -> Custom -> 0,00 " mm"

**twofootgiant** · 09-30-2009, 07:47 AM

Hi

Thanks for the reply

This changes the original cell but doesnt make a difference to the concatenate formula. The formula still displays "3" not 3.00.

Lets say A1 contains 3.00
And lets say my formula is =concatenate("abcd"," ",A1,"mm") in cell B1.

The end result at the moment in B1 is "abcd 3mm"
i need it to be "abcd 3.00mm

**zbor** · 09-30-2009, 07:49 AM

Perhapes =concatenate("abcd"," ",ROUND(A1,2),"mm")

Going to test it

**twofootgiant** · 09-30-2009, 07:53 AM

Nope..No Luck

**NBVC** · 09-30-2009, 07:57 AM

Try

=concatenate("abcd"," ",Text(A1,"0.00"),"mm")

**twofootgiant** · 09-30-2009, 08:28 AM

excellent

Thanks Guys

**NBVC** · 09-30-2009, 09:04 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save