Concatenate with Formatting

**telton** · 11-13-2007, 02:03 AM

Hi,

I want to concatenate a statement with a $ figure in it.

eg. =concatenate("for the sum of ",A6," on....etc")

I want this value to be frmatted as it appears in the cellit is coming from

ie. $ 19,107.20, not 19107.2

is this possible

Thanks

**VBA Noob** · 11-13-2007, 02:11 AM

Maybe

="for the sum of "&DOLLAR(A6)&" on....etc"

or

="for the sum of "&TEXT(A6,"$0.00")&"""on.etc"

VBA Noob

**telton** · 11-13-2007, 05:08 PM

Legend, Thank you !

**VBA Noob** · 11-13-2007, 05:09 PM

Your welcome

VBA Noob

Concatenate with Formatting

LinkBack

Thread Tools

Rate This Thread

Display

Concatenate with Formatting

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions