SOLVED

FORMULA

Copper Contributor

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

2 Replies
best response confirmed by VI_Migration (Silver Contributor)
Solution

@lissag555 

Use the TEXT function:

 

='Cheat Sheet'!A30&TEXT('Cheat Sheet'!B3, "#,##0.00")

PERFECT !!!! thank you soooo much
1 best response

Accepted Solutions
best response confirmed by VI_Migration (Silver Contributor)
Solution

@lissag555 

Use the TEXT function:

 

='Cheat Sheet'!A30&TEXT('Cheat Sheet'!B3, "#,##0.00")

View solution in original post