COMBINING TWO COLUMNS THAT ARE CURRENCY

  • Thread starter Thread starter Donna
  • Start date Start date
D

Donna

I have 2 columns that I want to merge together and I used =A2&B2 and that
part works, but it won't let me format it back to currency? If you merge two
columns together and then later want to merge another one into the already
merged column, is that what's messing it up?
Thanks
Donna
 
The & operator returns the two numbers as text.

To see some formatting..............

=TEXT(A2&B2,"$#,##0.00")

BTW...........you are not merging columns...........you are combining
columns.

"merging" is a dirty word around here<g>


Gord Dibben MS Excel MVP
 
Back
Top