How To Format Numbers? I want to format [452365214] as [452, 365, 214].

[M S Salimi]

Hello;

I want to format [452365214] as [452, 365, 214]. Separating by comma and space.

 

[RoryA]

Assuming the cell has just the number without the square brackets, you can use:
0, 000, 000
as a custom format code. If the square brackets are actually part of the cell, then a number format will not work.

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

I want to format [452365214] as [452, 365, 214].

Hello; I want to format as . Separating digits by comma and space.

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[M S Salimi]

Assuming the cell has just the number without the square brackets, you can use:
0, 000, 000
as a custom format code. If the square brackets are actually part of the cell, then a number format will not work.

 

[Rick Rothstein]

I see your values are text (they are all left aligned)... you will not be able to format such a cell.

 

[M S Salimi]

I see your values are text (they are all left aligned)... you will not be able to format such a cell.

 

[Rick Rothstein]

I don't understand your post. Are you trying to tell me (us) that your version of Excel displays left to right or that your cell's alignment is left justified? Either way, I do not think you can get both the comma and space between the digit triples using cell formatting. If you are willing to have the numbers display the way you indicated using a formula in another cell... that can be done, but the values will be text.

=SUBSTITUTE(TEXT(G20,"#,###"),",",", ")

 

[RoryA]

You already have an answer in your cross-posted thread so I see little point in carrying on here.

 

[M S Salimi]

I don't understand your post. Are you trying to tell me (us) that your version of Excel displays left to right or that your cell's alignment is left justified? Either way, I do not think you can get both the comma and space between the digit triples using cell formatting. If you are willing to have the numbers display the way you indicated using a formula in another cell... that can be done, but the values will be text.

=SUBSTITUTE(TEXT(G20,"#,###"),",",", ")

Thank you for your guidance.