Formatting numbers in a general cell in Excel

I have a value of 1500.00 in A1 that displays, as currency as $1,500.00
and a value of 2500.00 in A2 that displays, as currency as $2,500.00

In a general cell, for example, A10 I have the phrase...

="This would range between "&A1&" and "&A2&"."

A10 displays...

This would range between 1500 and 2500. Of course I want $1,500.00 and $2,500.00

Clueless here and obviously not too bright  this morning.
LVL 1
Bill GoldenExecutive Managing MemberAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You simply need to put this in A10
="This would range between "&DOLLAR(A1)&" and "&DOLLAR(A2)&"."

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Saqib Husain, SyedEngineerCommented:
="This would range between "&text(A1,"_($* #,##0.00_);_($* (#,##0.00);_($* ""-""??_);_(@_)")&" and "&text(A2,"_($* #,##0.00_);_($* (#,##0.00);_($* ""-""??_);_(@_)")&"."
Bill GoldenExecutive Managing MemberAuthor Commented:
Excellent.  Works great.  Saqib your example was interesting but relatively complex.  Went with the simple solution.
Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Glad to help BluSkyBill!
Saqib Husain, SyedEngineerCommented:
sktneer's solution is definitely better than mine. I never knew that such a function existed so education for me.

My solution can be applied to all other types of formats. All you have to do is copy the custom number format of the cell to the formula. Also I think the dollar function would not work in 2003.
Bill GoldenExecutive Managing MemberAuthor Commented:
Running 2003 and the DOLLAR function worked great.  Next question is a little more complicated, but builds on the same cell.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.