Using REGEXREPLACE to insert commas into values in Google Sheets

Viewed 90
3 Answers

Try

=A1

and change the format to

#,##0

To insert commas into values in Google Sheets, I recommend:

  • Select the range of cells you'd like to format or modify.
  • Click Format and then Number.
  • Select the format to apply to the range of cells.
Related