Joint two strings with amount

[SMILE]

Hi Friends
Can I get a clue how to join two stings with an amount
In A1 I have "Descr "
In B1 I have "January "
in C1 i have a value 30.000
I need the result in d1 as "Descr January 30.000"
I use Range("a1").value & Range("B1").value & Range("c1").value but I am stuck with the number format it gives me the result "Descr January 30"
Can someone correct the same above example.
Thanks

[nathansav]

Range("a1").value & Range("B1").value & FIXED(Range("c1").value,3)

[SMILE]

SORRY... it gives me an error
compiling error
Sub or Function not defined
the following is my exact code i pasted

Please Login or Register  to view this content.

[Fotis1991]

=a1&b1&text(c1,"#.###000") ????

[SMILE]

I need a VB code

[nathansav]

Ok, sorry i put it as a worksheet function

DESC1 = Range("a10").Value & "-" & Range("c10").Value & Format(Range("b10").Value, "#.##0")

[SMILE]

Thanks nathansav... perfect