I apply text format from the format cells dialogue box or put an apostrophe
at the beginning of the text. It displays whatever I write.
Perhaps you need something else.
With best regards,
Amiyo Biswas
Cell: +91-9433464329
----- Original Message -----
From: "Mukesh" <[email protected]>
To: <[email protected]>
Sent: Thursday, May 30, 2013 6:02 AM
Subject: [AI] Cell format for phone numbers
Dear friends,
I want to write a phone number in excel as +91-0253-1234567 format. I
change a cell format to custom as follows:
"+91"-0000-00000000
But I have a problem in phone number display that is our some state codes
are 3 and 4 digits and local numbers are 6, 7, 8 digits. In this case the
display is not correct.
Please give me a solution please.
Thanking you in anticipation.
Regards
Mukesh Baviskar
Mobile: 9403161157
Register at the dedicated AccessIndia list for discussing accessibility of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/[email protected]/
To unsubscribe send a message to
[email protected]
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Disclaimer:
1. Contents of the mails, factual, or otherwise, reflect the thinking of
the person sending the mail and AI in no way relates itself to its
veracity;
2. AI cannot be held liable for any commission/omission based on the mails
sent through this mailing list..
Register at the dedicated AccessIndia list for discussing accessibility of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/[email protected]/
To unsubscribe send a message to
[email protected]
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes, please
visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Disclaimer:
1. Contents of the mails, factual, or otherwise, reflect the thinking of the
person sending the mail and AI in no way relates itself to its veracity;
2. AI cannot be held liable for any commission/omission based on the mails sent
through this mailing list..