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
Kevin@Radstock Posts 42 Registration date Thursday January 31, 2013 Status Member Last seen April 26, 2014 - Apr 26, 2014 at 12:49 AM
Related:
- Concatenate cells losing comma formatting
- Matlab concatenate matrix - Guide
- Clear only the formatting from the selected cell (leaving the content) - Guide
- Conditional formatting if two cells match ✓ - Excel Forum
- How to unlock file safe in vivo without password without losing data - Phones, PDA & GPS Forum
- How would you change all cells containing the word pass to green - Excel Forum
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Apr 25, 2014 at 05:18 PM
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
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
Apr 26, 2014 at 12:49 AM
=TEXT(A1,"$#,##0")&"-"&TEXT(B1,"$#,##0")&"-"&TEXT(C1,"$#,##0")