Custom Number format

%3CLINGO-SUB%20id%3D%22lingo-sub-1687500%22%20slang%3D%22en-US%22%3ECustom%20Number%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1687500%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20would%20I%20show%20number%20using%20%22%2C%22%20like%20this%2099%2C99%2C99%2C999%2C999.99%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1687500%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1687552%22%20slang%3D%22de-DE%22%3ESubject%3A%20Custom%20Number%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1687552%22%20slang%3D%22de-DE%22%3E%3DA1%26amp%3B%22%20%2C%26amp%3BB1%26amp%3B%22%20%2C%26amp%3BC1%26amp%3B%22%2C%22D1%26amp%3B%22%20...%20ect.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20I%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%20*%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

How would I show number using "," like this 99,99,99,999,999.99

4 Replies
Highlighted
=A1&" ,"&B1&" ,"&C1&","D1&" ...ect.

I would be happy to know if I could help.

Nikolino
I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Highlighted

@sahismail 

Afraid no way, that's if only to play with digits grouping in Windows settings

Win+R

control international

Additional settings

Highlighted
Sometimes it is desperate with the translation.
Would you like to combine the numbers from cells, or do you want custom formatting? ... Have to rely on my feelings when translating.
My first approach was the same, but I thought that this is not the self-evident. It may be self-evident for me, but not for others.
I must not lose my head that I am here to help and when I need it, I will be helped too.

I cannot do great things - only small ones, but those with great love.
Mother Teresa©

Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
Highlighted

@sahismail ,,

 

Up to certain digits specific Number format is possible, otherwise you need to check the Regional settings, below shown formats are using US Keyboard and US English.

 

Rajesh-S_0-1600601268217.png

 

  • Applied format on cell N38 is, 

 

[>9999999999999]##","##","##","###.00;[>999999999999]##","##","###.00;#,###.00

 

  • Format on cell N40 is, 

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