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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Saqib Husain
="This would range between "&text(A1,"_($* #,##0.00_);_($* (#,##0.00);_($* ""-""??_);_(@_)")&" and "&text(A2,"_($* #,##0.00_);_($* (#,##0.00);_($* ""-""??_);_(@_)")&"."
ASKER
Excellent. Works great. Saqib your example was interesting but relatively complex. Went with the simple solution.
Glad to help BluSkyBill!
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.
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.
ASKER
Running 2003 and the DOLLAR function worked great. Next question is a little more complicated, but builds on the same cell.