Excel 2003 formula: keep currency format when putting text and number in same cell

First post here, and my situation is this:

I am trying to create a formula in which I can pull a number from a cell in another worksheet (but in the same workbook) and put it in the middle of a text cell. I got the basics of it with this formula:

Please Login or Register  to view this content.

The problem I am having is that the number I am trying to pull in from the Quote worksheet is a currency value that needs to have 2 decimal places. I thought the formula I listed would bring the number over exactly as it is displayed on the Quote sheet, but I find that if the value of the cents ends in 0 (i.e., $214.10) it is dropping the 0, so I end up with $214.1 displaying.

Any thoughts on a better way to do this, or a way to make that 2nd decimal place show?

Thanks,
Paula

Try:

="We can invoice you either quarterly at " & TEXT(Quote!H3,"$#,##0.00")

Aha! That did it. Thank you so much!!

Paula