MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Format numbers in combining cells


Posted by Mike Absher on December 20, 2001 7:53 AM

I have the following spreadsheet set up:

Where cell A1 = $12500.50
and B1 = $202.50 (Calculated field)

when I used this formula for A3:

=A1& " " & B1

I get the following result

12500.5 202.5083311

I need both formatted as $ carried to two digits. How do I format these numbers within my formula for cell A3?

Mike


Posted by Mark W. on December 20, 2001 7:59 AM

=TEXT(A1,"$###0.00")&" "&TEXT(B1,"$###0.00") (nt)

Posted by Mark W. on December 20, 2001 8:01 AM

Actually, =TEXT(A1,"$0.00")&" "&TEXT(B1,"$0.00")will suffice! (nt)

Posted by GREGC on December 20, 2001 8:02 AM

=DOLLAR(A1,2) & " " & DOLLAR(B1,2)

Posted by Mark W. on December 20, 2001 8:06 AM

DOLLAR uses a comma (nt)

Posted by Mike Absher on December 20, 2001 8:10 AM

Re: =TEXT(A1,"$###0.00")&" "&TEXT(B1,"$###0.00") (nt)

Thanks...worked just fine!