Formatted Numbers & statements (2000)

Topic

New Reply

Hi…

I have three columns that I am putting together as one column:

=F87&” “&E87&” “&AC87&” “&G87

Column G is formatted so that it has no decimal points, but does have a dollar sign and commas.

How can I make the formatting ‘stick’ so that it is there in the new column..

Thanks!

Reply | Quote

Replies

Does Column G contain currency formatted numbers? Try =F87&” “&E87&” “&AC87&” “&TEXT(G87,”$#,##0”)

Reply | Quote

Thank you soooo much..

That is exactly what I needed and worked perfectly..

Reply | Quote