Remove decimal point and numbers after decimal point using custom number formatting

[Jinson]

Hello Team,

I have to display certain amount in lacs (1,00,000), and therefore using custom number formatting I came up with 0\.00,

Eg : 10,00,000 is shown as 10.00 after using the custom number format
20,00,000 is shown as 20.00 after using the custom number format

But now I want the output as follows

10,00,000 as 10 (without decimal point and numbers after decimal point)
20,00,000 as 20 (without decimal point and numbers after decimal point)
30,00,000 as 30 (without decimal point and numbers after decimal point)

I do not want to show decimal point and numbers after decimal point after applying the custom number format.

Looking for a solution which can be made via custom number formatting dialog box.

Thank you in anticipation

 

[kvsrinivasamurthy]

Try this formula
A2=1000000

=INT(A2/100000)

 

[Jinson]

Thank you for your response !

But want a solution using custom number formatting technique

 

[abdelfattah]

But want a solution using custom number formatting technique

I'm not sure if I understand you correctly

make sure Decimal Places is zero and unchecked choice "Use 1000 separator() from Cells Formatting.

 

[Scott Huish]

That's not a US format so I'm not 100% sure but does this work?
0,.00

 

[Jinson]

I'm not sure if I understand you correctly

make sure Decimal Places is zero and unchecked choice "Use 1000 separator() from Cells Formatting.

Hello Abdel,

I have tried these and it doesn't work. When you use a "custom" formatting, you can use 1000 separator but the output is not what you want

 

[Jinson]

That's not a US format so I'm not 100% sure but does this work?
0,.00

Hey Scott it did not work unfortunately.

let me reiterate

After using the "custom" formatting <0\.00,> (ignore the <> symbols) the output is displayed with decimals and decimal point. I do not want decimal points to be displayed

Eg : 10,00,000 is shown as 10.00 after using the custom number format
20,00,000 is shown as 20.00 after using the custom number format

But now I want the output as follows

10,00,000 as 10 (without decimal point and numbers after decimal point)
20,00,000 as 20 (without decimal point and numbers after decimal point)
30,00,000 as 30 (without decimal point and numbers after decimal point)

 

[Fuji]

Try the custom cell format
enter 6 0s (000000)
click between first and second 0s and hit Ctrl + J and OK
format cell as Wrap Text.

 

[abdelfattah]

I have tried these and it doesn't work

did you do like this picture as marked?

if it's so I have no idea !

sorry buddy !

 

[Jinson]

Try the custom cell format
enter 6 0s (000000)
click between first and second 0s and hit Ctrl + J and OK
format cell as Wrap Text.

Hello Fuji !!

This worked for me buddy !!!

Cheers