Calling up Currency Value From Another Sheet

[Mina_Minic]

I'm trying to call up a dollar value from another sheet to my quote sheet.
I want the cell to have text followed by the amount. Example "cost of the dark scheme is $1,234"
My current formula works as far as to bring up the value, but not in currency format.
This is what I have now:
="cost of the dark scheme is" &'sheet2!G10
It works but the outcome has no currency formatting even though the cell that it is calling it up from is correctly formatted; it just spits out a number rounded to 3 decimal places and no dollar sign.
Can anyone help please?

 

[teylyn]

Formatting does not get across when referencing a cell. Formatting is just decoration. The formula only pulls the underlying value.

Therefore you need to apply the formatting to the value. If you combine the value with another piece of text, you can wrap the reference to the other cell into a TEXT() function with a formatting string.

try

="cost of the dark scheme is " &text('sheet2'!G10 ,"$#,##0.00")

 

[Mina_Minic]

Thank you very much teylyn