formula for formatting

[planetstella]

I have a spreadsheet (named Source) that has values, and would like it to display like this in the final spreadsheet: (XXX, XXX). I can't figure out how to get the final spreadsheet to preserve the decimal settings that have been set in the Source spreadsheet.

Using this formula in the final spreadsheet:
=" ("&Source!H5&", "&Source!I5&")"

 

[VoG]

Try like this

=" ("&TEXT(Source!H5,"0.00")&", "&TEXT(Source!I5,"0.00")&")"

 

[Muhamed Faizal]

Peter is already given solution

However I prepared the following hence posting.

=" ("&TEXT(Source!H5,"###.00")&", "&TEXT(Source!I5,"###.00")&")"

 

[planetstella]

Thank you - that worked!