Showing Decimal Places from another sheet

[jillianbutt_12]

I'm trying to use numbers from one sheet on another sheet, but when i use the numers combined in a formula with words, the numbers only use 2 decimal places if they're not zero

so for example if one of the numbers is 5435.40, in the second sheet the number just comes as 5435.4

is there any way i can get that zero there or is it a lost cause?

here's an example of one of the formula's i'm trying to use:

="Expenses (allowance) = $"&'Sheet2'!B9

 

[VoG]

Try

="Expenses (allowance) = "&DOLLAR(Sheet2!B9)

 

[eblake]

If you don't want the dollar sign you can use
="Expenses (allowance) = " & TEXT(Sheet2!B9,"#.00")

 

[jillianbutt_12]

It worked! Thanks a million