100 separator in Excel

[SandeepKumar]

Hi All,

I need custom number format for 100 separator .
can Anyone please provide me the Number format.

Thanks,
Sandeep

 

[Sixthsense]

May be this?

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

 

[SandeepKumar]

May be this?

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

Hi Sixthsense,

Custom format doesn't work for me

 

[pgc01]

Hi Sandeep

Can you elaborate?

What's your range of numbers?

Please give examples of all relevant cases.

 

[SandeepKumar]

Hi Sandeep

Can you elaborate?

What's your range of numbers?

Please give examples of all relevant cases.

Hi ,

Range of numbers is 1000000.

For example if 1000 is mapped on some cell then data should divisible by 100 means 10 is the actual data.

Thanks,
Sandeep