How to format numbers in excel in crores or lacks

Question

For example, I want something like 1 cr if we enter in cell 10,000,000. I have tried number formatting like many available but not a single one is doing my job.

Answer 1

Try this:

=TEXT(A1/10000000,"#,### \cr")