Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 125
  • Last Modified:

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.
0
IO_Dork
Asked:
IO_Dork
1 Solution
 
Angelp1ayCommented:
Keep the numbers as numbers and add another column with this formula which creates a string version with the desired formatting:
=TEXT(A1,"#,##0.00")

Open in new window

0
 
IO_DorkAuthor Commented:
perfect!
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now