Re: [AI] Number format in excel
Type +91253 instead 0253 On 5/14/13, Mukesh mukeshbaviskar@gmail.com wrote: Hello friends, I want to type std code of Nashik in cell 'j6' as 0253 but when I type 0253 excel displays 253 which I don't want. I tried to change the cell number format but I didn't get the appropriate format for it. Please suggest me the proper number format to display std code as 0253. 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/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in 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.. -- Akhilesh Dahiya, Advocate. Mobile: +91 9818798780 Email: akhil.akhi...@gmail.com New Delhi 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/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in 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..
Re: [AI] Number format in excel
Thank you but it's not a proper way to write std codes. There may be a trick/format to write such numbers starting with zero in excel. Waiting to get solution from excel users today. Regards Mukesh Baviskar Mobile: 9403161157 -- From: akhilesh akhil.akhi...@gmail.com Sent: Wednesday, May 15, 2013 3:22 AM To: accessindia@accessindia.org.in Subject: Re: [AI] Number format in excel Type +91253 instead 0253 On 5/14/13, Mukesh mukeshbaviskar@gmail.com wrote: Hello friends, I want to type std code of Nashik in cell 'j6' as 0253 but when I type 0253 excel displays 253 which I don't want. I tried to change the cell number format but I didn't get the appropriate format for it. Please suggest me the proper number format to display std code as 0253. 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/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in 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.. -- Akhilesh Dahiya, Advocate. Mobile: +91 9818798780 Email: akhil.akhi...@gmail.com New Delhi 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/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in 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/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in 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..
Re: [AI] Number format in excel
Hi Mukesh, press ctrl + 1, under number tab Change the cell format category into Text and you will get desired result. On 5/15/13, Mukesh mukeshbaviskar@gmail.com wrote: Thank you but it's not a proper way to write std codes. There may be a trick/format to write such numbers starting with zero in excel. Waiting to get solution from excel users today. Regards Mukesh Baviskar Mobile: 9403161157 -- From: akhilesh akhil.akhi...@gmail.com Sent: Wednesday, May 15, 2013 3:22 AM To: accessindia@accessindia.org.in Subject: Re: [AI] Number format in excel Type +91253 instead 0253 On 5/14/13, Mukesh mukeshbaviskar@gmail.com wrote: Hello friends, I want to type std code of Nashik in cell 'j6' as 0253 but when I type 0253 excel displays 253 which I don't want. I tried to change the cell number format but I didn't get the appropriate format for it. Please suggest me the proper number format to display std code as 0253. 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/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in 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.. -- Akhilesh Dahiya, Advocate. Mobile: +91 9818798780 Email: akhil.akhi...@gmail.com New Delhi 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/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in 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/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in 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.. -- Jyotsna 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/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in 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..
Re: [AI] Number format in excel
Hello Jyostna, Thank you for solution. It's working fine. Regards Mukesh Baviskar Mobile: 9403161157 -- From: Jyotsna jyotsnadi...@gmail.com Sent: Wednesday, May 15, 2013 7:00 AM To: accessindia@accessindia.org.in Subject: Re: [AI] Number format in excel Hi Mukesh, press ctrl + 1, under number tab Change the cell format category into Text and you will get desired result. On 5/15/13, Mukesh mukeshbaviskar@gmail.com wrote: Thank you but it's not a proper way to write std codes. There may be a trick/format to write such numbers starting with zero in excel. Waiting to get solution from excel users today. Regards Mukesh Baviskar Mobile: 9403161157 -- From: akhilesh akhil.akhi...@gmail.com Sent: Wednesday, May 15, 2013 3:22 AM To: accessindia@accessindia.org.in Subject: Re: [AI] Number format in excel Type +91253 instead 0253 On 5/14/13, Mukesh mukeshbaviskar@gmail.com wrote: Hello friends, I want to type std code of Nashik in cell 'j6' as 0253 but when I type 0253 excel displays 253 which I don't want. I tried to change the cell number format but I didn't get the appropriate format for it. Please suggest me the proper number format to display std code as 0253. 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/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in 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.. -- Akhilesh Dahiya, Advocate. Mobile: +91 9818798780 Email: akhil.akhi...@gmail.com New Delhi 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/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in 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/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in 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.. -- Jyotsna 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/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in 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