MS EXCEL, Number Format

**thanksgod** · 21st January 2010, 05:04 AM

Salam Alikum,

I want to format a long number (eg: 123456789) so the result must be
like: 12,34,56,789.
While applying Custom-Format, the result is always appearing like: 123,456,789
I have unchecked the thousand-separator in NUMBER tab but result is the same. I am using excel 2007.
Please guide me to solve this issue.
Thanks

**syar** · 21st January 2010, 11:25 AM

salam::

use custom formatting. Ist select your cell or range and go to custom formatting and pase this .

Code:

####","##","##","###.00

hope this will help you.

regards

**thanksgod** · 21st January 2010, 05:30 PM

Dear Brother, Salam Alikum,

This has been a great answer. I appreciate your help. The problem is solved.
May God bless to all of us.

Best Regards
M.Ahmed

Jeddah

**superid** · 21st January 2010, 07:04 PM

problem solved close the thread

**sohail1966** · 30th July 2012, 02:45 PM

..............

**azhar aali** · 30th July 2012, 03:48 PM

syar said:

salam::

use custom formatting. Ist select your cell or range and go to custom formatting and pase this .

Code:

####","##","##","###.00

hope this will help you.

regards

Bro yah code apply kider ho ga? and kasy?

**syar** · 30th July 2012, 08:27 PM

azhar aali said:

Bro yah code apply kider ho ga? and kasy?

apne range/cell select karain
right click---->format Cell---->Number ki catageroy m custom ko select kar k code paste kar dain

regards

**Muhammad riz** · 30th July 2012, 08:30 PM

good

***Xpert~Baba*** · 30th July 2012, 08:41 PM

thanksgod said:

Dear Brother, Salam Alikum,

This has been a great answer. I appreciate your help. The problem is solved.
May God bless to all of us.

Best Regards
M.Ahmed
Jeddah