Solved

# Excel: Return number within text to two decimal places

Posted on 2014-04-13
423 Views
Hello,

I have the following formula in an excel cell:

="Test text \$"&(C10-D10)&" test text"

I would like the value in the middle to return as two decimal places. Currently it only returns as 1 decimal place.

e.g: Test text \$32.4 test text

But I want: Test text \$32.40 test text

How do I edit the formula so it returns two decimal places?

0
Question by:dabug80
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 22

Accepted Solution

Flyster earned 500 total points
ID: 39998126
See if this works for you:

="Test text \$"&TEXT(C10-D10,"#.00")&" test text"

Flyster
0

LVL 1

Author Closing Comment

ID: 39998133
Great. This works perfectly
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
###### Suggested Courses
Course of the Month5 days, 12 hours left to enroll