Thread
:
HOW DO I CREATE MULTIPLE CURRENCY
View Single Post
#
4
GerryK
Posts: n/a
="$ "&TEXT(A1,"0")&" - $ "&TEXT(B1,"0")
If in A1 is 60 and in B1 is 70 then in C1 put:
HTH
-----Original Message-----
HOW DO I CREATE MULTIPLE CURRRENCY NUMBERS IN ONE CELL.
I.E. $60 - $70
.
Reply With Quote