----------------------------------------------------------- New Message on MumbaiUserGroup
----------------------------------------------------------- From: Coolajit5 Message 4 in Discussion Hi, I tried it out and it worked. You will have to use the format cells option to get the number in the desired format. 1. Right click on a cell. 2. In the context menu, say 'Format Cells' 3. In the number tab, select category 'Custom'. 4. In the type text box type in 13 zeros. This will solve your problem. I've attached a small screen shot (zipped bmp) with the 'Format Cells' dialog and the excel sheet's 'A1' cell displaying the data as 0089615670000. Regards, Ajit View Attachment(s): http://groups.msn.com/MumbaiUserGroup/_notifications.msnw?type=msg&mview=1&parent=1&item=3819 ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/MumbaiUserGroup/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
