View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default COMBINING TWO COLUMNS THAT ARE CURRENCY

Look in the help index for DOLLAR

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Donna" wrote in message
...
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