Problem with concatenate

[HVK1986]

Hi all,

1)i have a value in cell A1=1243848. Now i want it as 12,43,848(with commas) in B1.

how to do it???


2)When i concatenate B1 with another cell, the commas will disappear.


Pls help

 

[Faseeh]

HARRY


How you can concatenate text within a cell?? do you want custom number formatting??


You can use this custom number formatting:

[>=10000000]###,##,##,##0;[>=100000]###,##,##0;##,##0

Select the cell and paste in custom number format.


Regards,

 

[HVK1986]

Thanks Faseeh,

i have problem with concatenating the values. suppose i have a value 1000 in A1, i want it as 1,000 or 10000 i want it as 10,000..like wise (Indian format). and when i use your formula in concatenating, the commas are again getting disappeared...


waiting for ur ans

 

[jason]

A1=1000

B1'=A1' then Right Click on B1 --> Format Cells --> Number Tab --> Select 'Number', adjust how many decimal places you wish you have (if any) and then check the box for 'Use 1000 Separator(,).


EDIT: It may be best if all of Col.B needs to have this same format that you select the entire column before going to Format Cells. otherwise, you'll have to apply the formatting to individual cells...unless thats needed.


NOTE: This formatting can be done to the original values in Col.A; eliminating the same values being in Col.B.


hope this helps!

 

[Hui]

Harry

Have you read: http://chandoo.org/wp/2010/07/26/indian-currency-format-excel/