Mar 28 2023 06:05 AM
I'm trying to pull in a cell with words from a secondary spreadsheet.
EX:
On your money market account, your total funds are $)
I have the formula currently as
='Cheat Sheet'!A30&'Cheat Sheet'!B3
(this first part I am pulling in text and the second part is the $ cell
it works just fine, but doesn't let me format the $ to #,###.##. It's not giving me the comma (,)
I've tried various combinations but I'm stuck here to fix that simple little tweak
Mar 28 2023 06:18 AM
SolutionMar 28 2023 06:18 AM
SolutionUse the TEXT function:
='Cheat Sheet'!A30&TEXT('Cheat Sheet'!B3, "#,##0.00")