Thread: [Solved] concatenate the currency too
View Single Post
 
Old 12-12-2015, 05:50 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,366
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by isasa74 View Post
At some point I used a formula to concatenate six cells, now two of them have a currency symbol along with the value (can be either USD or EUR) and I would need the symbol being concatenated as well.
Unless the cells contain text, the currency symbols are just cell formatting and are not part of the values themselves. That said, you should be able to retrieve the format if you change the way you're populating the array. For example, instead of:
.Cells(I, 2)
to return the value you might use:
.Cells(I, 2).Text
to return the formatted value.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote