$$Excel-Macros$$ Re: Leading zeros
Hi John, Use ' before 0 os it will display number as '0985542. Rgds, MB On Tue, May 19, 2009 at 7:21 PM, john wrote: > > I have a basi questions. When I try to enter a number with a leading > zero, it ignores the zero and enters the rest. Where do I go to > correct this so all numbers including the leading zero be entered and > displayed? > > > > -- With Love, Mahesh Bisht --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Leading zeros
Dear John and all Apart from the many solutions suggesting formatting as text or adding the ' sign, you could custom format the cell, thus retaining the number format and having the leading zeroes at the same time. For example if your numbers are of a fixed length of 6 digits so that "15" is to be displayed as "15", you could custom format the cell/cells using the format cell dialogue box and typing 00 using custom format. Anil Kumar Agarwala Guwahati : 781001 Assam akagarw...@gmail.com -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of john Sent: Tuesday, May 19, 2009 7:22 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Leading zeros I have a basi questions. When I try to enter a number with a leading zero, it ignores the zero and enters the rest. Where do I go to correct this so all numbers including the leading zero be entered and displayed? --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Leading zeros
*Hi John,* One way could be formatting the cell as Text Format. Please find the attached sheet with the same format. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Tue, May 19, 2009 at 7:21 PM, john wrote: > > I have a basi questions. When I try to enter a number with a leading > zero, it ignores the zero and enters the rest. Where do I go to > correct this so all numbers including the leading zero be entered and > displayed? > > > > --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~--- leading Zeros - Dkp.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Leading zeros
Hi John, You need to change the format of the columns where you want numbers with leading zeros to 'Text format'. Another option if there is for example only one number you want with a leading zero is to preceed the number with an " ' ", for example if you want to enter the number 07545 then in the cell you would type: '07545. This is also another alternative to change the number to text. Hope this helps. Regards, Amitabh > Date: Tue, 19 May 2009 06:51:32 -0700 > Subject: $$Excel-Macros$$ Leading zeros > From: johnbah...@hotmail.com > To: excel-macros@googlegroups.com > > > I have a basi questions. When I try to enter a number with a leading > zero, it ignores the zero and enters the rest. Where do I go to > correct this so all numbers including the leading zero be entered and > displayed? > > > _ More than messages–check out the rest of the Windows Live™. http://www.microsoft.com/india/windows/windowslive/ --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Leading zeros
prefIX the zero with an "'' On 5/19/09, john wrote: > > I have a basi questions. When I try to enter a number with a leading > zero, it ignores the zero and enters the rest. Where do I go to > correct this so all numbers including the leading zero be entered and > displayed? > > > > --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Leading zeros
Write it like this *'*00012345 note the *' symbol infront of the text you write in the cell* ** Regards, Andy On Tue, May 19, 2009 at 8:51 PM, john wrote: > > I have a basi questions. When I try to enter a number with a leading > zero, it ignores the zero and enters the rest. Where do I go to > correct this so all numbers including the leading zero be entered and > displayed? > > > > --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---