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

 

[Jinson]

did you do like this picture as marked?
View attachment 118175
if it's so I have no idea !

sorry buddy !

Thank you for your responses !!

 

[Fuji]

You are welcome and thanks for the feedback.

 

[Scott Huish]

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.

I didn't know about this. This is quite useful. Thanks!!

 

[Fuji]

Entering Ctrl + J is to place a line break so, it actually looks like below in the cell.

10 00000