| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
,000 Separator after Concatenate
Hi,
If i concatenate two cells or more than that , and I could see that after concatenation I loose Thousand separator from numeric values, please advise how can we have '000 separator to numeric values even after they are concatenated. SS |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
,000 Separator after Concatenate
Adjust the format of the number ot suite...
=A1& " " & TEXT(B1, "#,##0.00") Where A1 is Text and B1 is a number... -- HTH... Jim Thomlinson "SANDIND" wrote: Hi, If i concatenate two cells or more than that , and I could see that after concatenation I loose Thousand separator from numeric values, please advise how can we have '000 separator to numeric values even after they are concatenated. SS |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
,000 Separator after Concatenate
On Wed, 19 Aug 2009 13:42:10 -0700, SANDIND wrote:
Hi, If i concatenate two cells or more than that , and I could see that after concatenation I loose Thousand separator from numeric values, please advise how can we have '000 separator to numeric values even after they are concatenated. SS Example A1: Text A2: 123,456,789.00 =a1 & " " & text(a2,"#,##0.00") --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use 100 separator inspite of 1000 separator in excel | Excel Worksheet Functions | |||
| list separator | Excel Discussion (Misc queries) | |||
| milliones separator | Excel Discussion (Misc queries) | |||
| Dot as time separator | New Users to Excel | |||
| I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel | |||
![SANDIND[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
