Solved

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

Posted on 2013-12-17
2
107 Views
Last Modified: 2013-12-17
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
Comment
Question by:IO_Dork
2 Comments
 
LVL 11

Accepted Solution

by:
Angelp1ay earned 500 total points
ID: 39724979
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
 

Author Closing Comment

by:IO_Dork
ID: 39725051
perfect!
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now