Is it possible to return the exact plain text value of a cell reference, including the number format, instead of the underlying data?

For instance, if a cell's underlying value is 2000 and the number format setting formats it as $2,000, I'd like to pull that string ($2,000) into another cell as plain text (eventually for use in a concatenation). Currently, referencing that cell simply returns 2000, omitting the $ and ,.

  • Please remember that as per site guidelines when an answer addresses your question, you should accept it so others can benefit as well. You can even upvote the answer. If you don't have enough reputation, your upvote will show up later, once you reach enough reputation points. Mar 16, 2022 at 16:53

1 Answer 1


This isn't possible in Google Sheets. You'd have to manually recreate the number format in your formula. Typically, you'd use the TEXT function, e.g.,



="Cost: "&TEXT(A2,"$#,#")



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.