HOW DO I CREATE MULTIPLE CURRRENCY NUMBERS IN ONE CELL. I.E. $60 - $70
N Niek Otten Nov 2, 2004 #2 Hi Eric, Can you elaborate a bit more on what you're trying to achieve? -- Kind Regards, Niek Otten Microsoft MVP - Excel
Hi Eric, Can you elaborate a bit more on what you're trying to achieve? -- Kind Regards, Niek Otten Microsoft MVP - Excel
F Frank Kabel Nov 2, 2004 #3 Hi not really sure what you're trying to do. What is your expected outcome? -- Regards Frank Kabel Frankfurt, Germany ERIC BROWN said: HOW DO I CREATE MULTIPLE CURRRENCY NUMBERS IN ONE CELL. I.E. $60 - Click to expand... $70
Hi not really sure what you're trying to do. What is your expected outcome? -- Regards Frank Kabel Frankfurt, Germany ERIC BROWN said: HOW DO I CREATE MULTIPLE CURRRENCY NUMBERS IN ONE CELL. I.E. $60 - Click to expand... $70
G GerryK Nov 2, 2004 #4 ="$ "&TEXT(A1,"0")&" - $ "&TEXT(B1,"0") If in A1 is 60 and in B1 is 70 then in C1 put: HTH
