Type Hindi numbers and show decimal numbers when necessary

[karammaged]

Hi, I have a workbook, it has integer and decimal numbers.

I want to achieve two things:

• The numbers must be in Hindi format.
• The decimal numbers must remain as they are without any rounding, and the integer numbers must remain as they are.

I want to achieve those two things with in mind other two things:

• The workbook will be shared for other people and need to appear to them like mine.
• Also, they could copy data from this workbook to another workbook and edit it.

What I did initially?

I highlighted the cells that has numbers and formatted it with custom type: [$-2000000]###0.#######. This make the numbers in cells are Hindi and keep any decimal numbers as they are, but when I put integer number, a comma appears with the number like this: 5.
I heard about using conditional formatting, but didn't work with me! Excel number format to only show decimals when necessary

Note: I think Excel could handle untill 15 decimal numbers after comma but in my case shows only 7 decimal numbers after comma and any other numbers won't show! (Yes, I tried to increase the limit here [$-2000000]###0.####### to 15 instead of 7 hastags, but it didn't work!).

What could we do? are there edits to what I have mentioned? are there other solutions? what could be most effective solution?
Thanks
This is an example:

Example.xlsx
	C	D	E	F	G	H	I
3		اختبار	اختبار	اختبار	اختبار	اختبار	اختبار
4	اختبار	٢.١	٥.	٥.	٩٦.٦٣	٢.١	٥.
5	اختبار	٩.٤٨٤٤٩٣	٢.١٨	٩.	٢.٥	٩.٤٨٤٤٩٣	٢.١٨
6	اختبار	٢.١	٥.	٥.	٩٦.٦٣	٥.	٩٦.٦٣
7	اختبار	٩.٤٨٤٤٩٣	٢.١٨	٩.	٢.٥	٩.	٢.٥
8	اختبار	٢.١	٥.	٥.	٩٦.٦٣	٥.	٩٦.٦٣
9	اختبار	٩.٤٨٤٤٩٣	٢.١٨	٩.	٢.٥	٩.	٢.٥
10	اختبار	٩.٤٨٤٤٩٣	٢.١٨	٩.	٢.٥	٩.	٢.٥
11	المجموع	٤٤.٢٣٧٩٧٢	٢٣.٧٢	٥١.	٢٩٩.٨٩	٤٨.٥٨٤٤٩٣	٢٠٧.٩٤
Sheet1

Cell Formulas
Range	Formula
D11:I11	D11	=SUM(D4:D10)

 

[karammaged]

Okay I want to share what I have found and let me know if this really a good solution or not.

1. I choose a cell (let us say C5), and open "Format cells" menu and choose "custom" from categoy then put this code in "Type" box: [$-2000000]0
2. After that, I open "Conditional formatting" from "Home" menu and choose "Manage Rules".
3. Press "New Rule" and choose"Use a formula to determine which cells to format" and type this formula =MOD(C5,1)<>0 where C5 is the cell I'm on it right now.
4. Then press "format" button while I'm on the same window, then choose number tab then choose the "custom" category and put this code [$-2000000]0.##########
5. then with "format painter" I could make all cells I want with the same format.

Exampleaaaaaa.xlsx
	C	D	E	F	G	H	I
3		اختبار	اختبار	اختبار	اختبار	اختبار	اختبار
4	اختبار	٣.٢٥	٥	٥	٩٦.٦٣	٢.١	٥
5	اختبار	٩.٤٨٤٤٩٣	٢.١٨	٩	٢.٥	٩.٤٨٤٤٩٣	٢.١٨
6	اختبار	٢.١	٥	٥	٩٦.٦٣	٥	٩٦.٦٣
7	اختبار	٩.٤٨٤٤٩٣	٢.١٨	٩	٢.٥	٩	٢.٥
8	اختبار	٢.١	٥	٥	٩٦.٦٣	٥	٩٦.٦٣
9	اختبار	٩.٤٨٤٤٩٣	٢.١٨	٩	٢.٥	٩	٢.٥
10	اختبار	٩.٤٨٤٤٩٣	٢.١٨	٩	٢.٥	٩	٢.٥
11	المجموع	٤٥.٣٨٧٩٧٢	٢٣.٧٢	٥١	٢٩٩.٨٩	٤٨.٥٨٤٤٩٣	٢٠٧.٩٤
Sheet1

Cell Formulas
Range	Formula
D11:I11	D11	=SUM(D4:D10)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D4:I11	Expression	=MOD(D4,1)<>0	text	NO