Cell format for India code +91-

[mukeshbaviskar]

Good morning friends,
I have phone number in column 'k' and I want to write the phone number as India code-state code-local number format.
For example:
+91-22-12344321
The cell format of column is text.
I don't want to write +91- for each entry. I want to display +91- by default in column 'k' so that I will start to enter the phone number from state code as in my example 22-12344321. It 's as a currency cell format in which we need not type dollar/rupee sign while entering the amount. We simply type the number and the currency sign displays before the number automatically.
Please suggest me a solution.
Thanking you in anticipation.

Mukesh

[shg]

Just enter the 10 digits and format as "+91-"00-00000000

The cell MUST be formatted as something other than Text (e.g., General, Number, ...)

[mukeshbaviskar]

Hello shg,
Ok! It's working fine but there are some errors in display. In India some state codes are 2, 3, 4 digits and local numbers are 6, 7, 8 digits in this case the display of phone number is not correct. any solution please. I used custom number format for it.
Thanking you for quick response.

Mukesh

[shg]

I have no idea what Indian phone numbers look like, sorry. Maybe someone else can help.