I have the following custom number format in my spreadsheet [COLOR=rgba(0, 0, 0, 0.84)][>=999950]0.0,,"M";[<=-999950]0.0,,"M";0.0,"K"[/COLOR] which makes 20,000 appear as 20.0K. My question is, how do I make it appear as a currency such as $20.0K? What do I need to add to the custom number format? (Please note this is in a Google sheet & not Excel).
Best
Eileen
Best
Eileen
Last edited by a moderator:
