SOLVED

Formula to include $ sign

Copper Contributor

I have a formula for my cell and it works. I want to put a dollar sign in that cell along with my total, so it reads $65 and not 65.

 

3 Replies

@missbetty68 

Press Ctrl+1 on staying on this cell and apply currency format if you have no such among accounting formats

image.png

best response confirmed by allyreckerman (Microsoft)
Solution

@missbetty68 Format the cell with the formula as currency or accounting with 0 decimal places.

Thank you
1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@missbetty68 Format the cell with the formula as currency or accounting with 0 decimal places.

View solution in original post