Formula to insert "," and ".00" where appropriate

I need to make a number column that is already formatted as string to contain the "," and ".00" in the proper places.  Formatting as a number does not help b/c the excel sheet I am comparing this data too has string values that contain the comma and ".00".  also the numbers can be anything from 0 and up.
Who is Participating?
Angelp1ayConnect With a Mentor Commented:
Keep the numbers as numbers and add another column with this formula which creates a string version with the desired formatting:

Open in new window

IO_DorkAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.