Previous Topic Next Topic

Concatenate cells losing comma formatting

Closed
meesh97 Posts 3 Registration date Monday February 10, 2014 Status Member Last seen April 25, 2014 - Apr 25, 2014 at 04:45 PM
Kevin@Radstock Posts 42 Registration date Thursday January 31, 2013 Status Member Last seen April 26, 2014 - Apr 26, 2014 at 12:49 AM
Hello,

I am trying to concatenate multiple number values into 1 string text, but I am losing the Comma formatting.

Here is an example of 3 values that I need concatenated:
cell A1 - $0
Cell B1 - $2,000,000
Cell C1 - $3,000,000

I am looking for the final string text to be - $0-$2,000,000-$3,000,000

But what I am seeing is that it is losing the commas in the number and displaying:
$0-$2000000-$3000000

Any help would be greatly appreciated.

Thanks!


1 response

Answer 1 / 1
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Apr 25, 2014 at 05:18 PM
meesh97, Good Evening.

Try to use it:
=TEXT(A1,"$#,###,##0")&"-"&TEXT(B1,"$#,###,##0")&"-"&TEXT(C1,"$#,###,##0")

Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0
Kevin@Radstock Posts 42 Registration date Thursday January 31, 2013 Status Member Last seen April 26, 2014 9
Apr 26, 2014 at 12:49 AM
You can shorten that to:

=TEXT(A1,"$#,##0")&"-"&TEXT(B1,"$#,##0")&"-"&TEXT(C1,"$#,##0")
0

Similar discussions

Unlock safe folder without losing any data
Mintu -
HelpiOS -

1 response
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
how to open file safe in vivo v11 without password
shivaraju -
Man -

3 responses