» Rounding Numerical Substrings
CATEGORY - Excel Financial Formulas
VERSION - All Microsoft Excel Versions
Problem: Rounding the numbers in the string stored in cell A2 (12.34567<>3.4567) to 3 decimal places.
Solution:
Use the ROUND, LEFT, FIND, and MID functions in the following formula:
=ROUND(LEFT(A2,FIND("<>",A2)-1),3)&"<>"&ROUND(MID(A2,FIND("<>",A2)+2,255),3)
Book Store:
Recommended Books:
- Analyzing Markets, Products, and Marketing Plans
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- Special Edition Using Microsoft Access 2002
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- Special Edition Using Microsoft Excel 2002
- Microsoft Excel VBA Programming for the Absolute Beginner
No comments have been submitted.
