» Rounding Numerical Substrings
CATEGORY - Excel Financial Formulas
VERSION - All Microsoft Excel Versions
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:
- Adventure Capitalist: The Ultimate Road Trip
- Millionaire Real Estate Mentor : The Secrets of Financial Freedom through Real Estate Investing
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Definitive Guide to Excel VBA
- Microsoft Excel VBA Programming for the Absolute Beginner
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
No comments have been submitted.
