displaying leading zeros

Is there a way to display leading zeros in a number and still have it 
formatted as a number?  We have account numbers for customers that often 
start with a zero.  When analyzing activity in Excel, the leading zeros are 
dropped.  It would be helpful if they would show.

Thanks
0
blkane (24)
2/17/2009 5:36:01 PM
excel 39879 articles. 2 followers. Follow

3 Replies
568 Views

Similar Articles

[PageSpeed] 57

Apply a custom format to the cells of 00000000 to display the numbers
as 8 digits, with leading zeros where appropriate.

Hope this helps.

Pete

On Feb 17, 5:36=A0pm, blkane <blk...@discussions.microsoft.com> wrote:
> Is there a way to display leading zeros in a number and still have it
> formatted as a number? =A0We have account numbers for customers that ofte=
n
> start with a zero. =A0When analyzing activity in Excel, the leading zeros=
 are
> dropped. =A0It would be helpful if they would show.
>
> Thanks

0
pashurst (2576)
2/17/2009 5:46:40 PM
Perfect!  I knew there was an easy answer.  I use a lot of complicated 
formulas but it is usually the small stuff that hangs me up.

"Pete_UK" wrote:

> Apply a custom format to the cells of 00000000 to display the numbers
> as 8 digits, with leading zeros where appropriate.
> 
> Hope this helps.
> 
> Pete
> 
> On Feb 17, 5:36 pm, blkane <blk...@discussions.microsoft.com> wrote:
> > Is there a way to display leading zeros in a number and still have it
> > formatted as a number?  We have account numbers for customers that often
> > start with a zero.  When analyzing activity in Excel, the leading zeros are
> > dropped.  It would be helpful if they would show.
> >
> > Thanks
> 
> 
0
blkane (24)
2/17/2009 6:38:03 PM
Glad it worked for you - thanks for feeding back.

Pete

On Feb 17, 6:38=A0pm, blkane <blk...@discussions.microsoft.com> wrote:
> Perfect! =A0I knew there was an easy answer. =A0I use a lot of complicate=
d
> formulas but it is usually the small stuff that hangs me up.
>
>
0
pashurst (2576)
2/17/2009 7:10:21 PM
Reply:

Similar Artilces:

Windows Display
I have a screen saver and I have it set to come on in 7 minutes. Then in display, I click the power button and I have my monitor to turn off after 45 minutes of inactivity. Well, it worked for over 3 years until now. Now my monitor will not turn off?? Any suggestions? Sometimes driver updates can cause a power savings issue. Also it may be a background service or app that is resetting the inactivity timer. Probably the last change made to the computer is likely the cause. You might try a System Restore if this is a fairly recent change. I wouldn't try to take the machine back ...

Outlook 2007 reply issue- displays very small
This is a multi-part message in MIME format. ------=_NextPart_000_00A7_01CA2BD1.6085C860 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable One of my coworkers has an issue with Outlook 2007 that is kind of odd. = This ONLY occurs on replies. When clicking "reply" the message displays with a VERY tiny view- = unreadable. The FONTS aren't changed, and the menu and other items on = screen aren't affected, only the display of the reply. When emailed, the = message displays properly- it is only the message view in the window =...

GP10 Create New User Navigation Tool Bar Does not display
After upgrading to Dynamics GP 10 from GP8 when I create a new user the toolbar navigation icons will not display. The default "Microsoft Dynamics GP" drop down does not display. I can use "CTRL-L" ->Toolbars -> Customize and then manually add the icons however I cannot get the default menus to display. Peter, It sounds your Command Bar Buttons (dbo.SY07125), Command Bar Options (dbo.SY07121), Command Customizations (dbo.SY07105), and Navigation Bar Buttons (dbo.SY07130) tables are corrupted. To restore access to the navigation options you will need to run t...

If Yes checked, display set of questions
I saw an access database that had a very cool form. There were 5 Yes/No options on the form. These were questions that applied to Quality Control. When a box was checked to indicate yes, additional questions with Yes/No options displayed below. Those questions that displayed asked questions about that particular Quality Control Topic question. I'm stuggling to figure out how that form was so interactive. Did each of the 5 questions have it's own subform, or was it as basic as "if this box is checked then display these questions". Any insight is appreciated. Tha...

How can you Display Inbox in Calendar view?
How can you Display Inbox in Calendar view? I know you can display TASKS in the calendar view, but can you display the inbox in the the calendar view? Or for that matter, can you display the journal in the calendar view in addition? ...

Email addresses display as Full Name field
A number of email addresses in my contacts display as the Full Name of that contact instead of the email address. When I double-click the email address field the Properties window appears, showing the proper email address. How do I get Outlook to just display the email address in the email address field? Display the email address where and in what version of Outlook? -- Russ Valentine [MVP-Outlook] "David Morrison" <davidbmorrison@comcast.net> wrote in message news:u01hIS%23mDHA.976@tk2msftngp13.phx.gbl... > A number of email addresses in my contacts display as the Ful...

formula to display cell address
I need a formula to display a cell address I want C1 to compare B1 to A1:A14 and bring back the cell reference if there is a match. In the below example C1 should read A2. Thanks in advance for any help. A B C 1 5 10 2 10 20 3 15 30 4 20 40 5 25 50 6 30 60 7 35 70 8 40 80 9 45 90 10 50 100 11 55 110 12 60 120 13 65 130 14 70 140 PiBJIHdhbnQgQzEgdG8gY29tcGFyZSBCMSB0byBBMTpBMTQgYW5kIGJyaW5nIGJhY2sgdGhlIGNl bGwgcmVmZXJlbmNlIGlmIHRoZXJlCj4gaXMgYSBtYXRjaC4KPiBJbiB0aGUgYmVsb3cgZXhhbXBs ZSBDMSBzaG91bGQgcmVhZCBBMi4KPiBUaGFua3MgaW4gYWR2YW5jZSBmb3IgYW55IGhlbH...

Changing what is displayed in the formula bar
Is there a way to change what is displayed in the formula bar. E.g. Cell B10 contains a number. This number is the result of a formula. The formula bar displays the formula. Can the formula bar display the number that is contained in cell B10 and not the actual formula? Thanks -- Christina L. Select B10. Pull-down Edit > Copy. Pull-down Edit > Paste Special as value. -- Gary''s Student "Christina L." wrote: > Is there a way to change what is displayed in the formula bar. > E.g. Cell B10 contains a number. This number is the result of a formula. &g...

Creating a Lead against existing info...
Guys, Is there a reasonable explanation why it's not possible to create a lead against an existing Account / Contact? It seems like a fundamental flaw to me. As I would like to be able to open an Account / Customer card and see all Leads associated to them... Thanks in advance Ben Hello Ben, Lead in a existing account/contact is usually opportunity. Shai B> Guys, B> Is there a reasonable explanation why it's not possible to create a B> lead against an existing Account / Contact? It seems like a B> fundamental flaw to me. As I would like to be able to open an B>...

Display color #2
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Is there a way to change the display colors for formatting marks (like the dots for spaces or the paragraph symbols). They are light blue on my display and I am slightly color blind so they are very difficult to see. I't like for them to just be black. Unfortunately, no. Use Help> Send Feedback to express your need to MS. Regards |:>) Bob Jones [MVP] Office:Mac On 10/30/09 4:29 PM, in article 59b7fa80.-1@webcrossing.caR9absDaxw, "MER@officeformac.com" <MER@officeformac.com> wrote: &g...

Display property sheet with property pages when multi-row
Hello NG I have a PropertySheet with many PropertyPages. As long as the pages fit together "next to each other", the page titles are displayed correctly: ______________________________ | Page 1 | Page 2 | Page 3 | Page 4 |________________________________ But now I have a small window, and the pages are not side by side but some are above the overs: ________________________ | Page 1 | Page 2 | | Page 3 | Page 4 | Page 5 | The actual page is shown correctly here. But the title names of all other pages are not shown. I first must click through al...

How do I display a list of cells and their values or formulas
Those of you who remember SuperCalc also remember that you could get a list of every cell in the spreadsheet and what was in that cell. It made a realy long list if you had a large spreadsheet and printed it all but was very handy in debugging. Does Excel have a similar feature, and how do you get to it if it does? Tools Options View Check Formula box "CalcMan" <CalcMan@discussions.microsoft.com> wrote in message news:E8B6ADAA-CEC9-4FA3-8B4E-F28EBA796F97@microsoft.com... : Those of you who remember SuperCalc also remember that you could get a list : of every cell in t...

Word 2004: Graphics cannot be displayed property in Word 2004
Neither Word not PowerPoint display graphics correctly. This problem is unique to Office 2004, and did not occur in Office v.X. We have reproduce the issue on several Mac machine. How can we resolve the issue? Any idea or suggestion will be highly appreciated. Thanks and best regards, Tony Leung Hi Tony, What kind of graphic file is giving you a problem? What is incorrect about the display? What OS are you using? What hardware are you using? Sorry to ask lots of questions, but the answers to the questions are important in order to try to reproduce the problem on another computer...

Store Employee ID in table, Display User Name in form
There are two tables and a form: tblAssets tblEmployees frmAssets tbleEmployees, among other things, has columns for User FirstName, User LastName, and EmployeeID. frmAssets primarily deals with tblAssets but pulls from other locations, including tblEmployees. frmAssets has field for EmployeeID, but not employees names. There are two requirements: 1) When displaying entries in frmAssets, I want to see the employees name corresponding to the EmployeeID stored for that asset record in tblAssets. 2) When entering new records in frmAssets, I want to be able to select the ...

Worksheet can not display picture
Hi!; I using Excel 2002 to create one worksheet and that worksheet inserted with a picture that created with AutoCAD. The picture can display properly on system Excel 2002 however it can not display on excel 2000 & 97. I tried to save as the document to 2000 & 97 compatible formats however still facing same problem. Someone ask me to change the display hardware acceleration, however it still doesn't solve the problem. I don't know what caused the problem; anyone can help me to solve the problem? Thanks & Regards I insert AutoCAD drawings into Excel by doing Insert > ...

How to add a vertical bar to a column chart to display AVERAGE val
I have a chart that summarizes survey responses: - Y axis is the percent of total respondents - X axis is the Likert scale responses, "Strongly Disagree (1)", thru "Strongly Agree (7)". I want to add a vertical bar that shows the average response (which the chart would take from the spreadsheet). For example, if the average was "5.5", I want the bar to be vertical, and for it to cross the X axis where 5.5 would fall, between the "Somewhat Agree (5)" and "Agree (6)" bars, as if the X axis were truly a numerical plotting (as oppose...

How do I format my column heading cells to display on an angle?
I would like to set up my column headings to display at an angle. I can put the text on an angle using Format>Alignment>Orientation but I would like the cell itself to appear on an angle as well. Thank you Put a border around those header cells - it will follow the orientation that you have set. Hope this helps. Pete On Feb 25, 9:16=A0pm, Kim <K...@discussions.microsoft.com> wrote: > I would like to set up my column headings to display at an angle. =A0I ca= n put > the text on an angle using Format>Alignment>Orientation but I would like = the >...

Page cannot be displayed when attempting to reset password offsite in OWA
For the past month, people have not been able to change their passwords offsite via OWA (they can onsite fine). Port 443 is not blocked on our firewall so I am not sure what is causing this. We have a certificate setup and I am not sure what it wrong - it is as if it is blocking port 443 but it is not blocked on the firewall (Cisco Pix). I followed several of the steps in the following article and I all still having problems... Suggestions as to what else to try? Thanks much, Toni P. http://support.microsoft.com/default.aspx?scid=kb;en-us;297121 I figured it out myself... Toni P. To...

cannot display the owa webpage
Hi, I am having the same problem, when I type the website address: https://mail.saloria.co.uk , it says "Internet Explorer cannot display the webpage" I was trying to install the Certification Authority. And after that I cannot access my OWA. What version of Exchange? Why didn't you enter .../exchange? -- Ed Crowley MVP - Exchange "Protecting the world from PSTs and brick backups!" "Marcus" <Marcus@discussions.microsoft.com> wrote in message news:44A87FC5-09A0-4EE5-BF50-E64B454330E1@microsoft.com... > Hi, > > I am having the same pro...

Line Display Issues #3
We recently purchased a PartnerTech CD7220 pole display for one of our customers for use with Microsoft RMS. Using the provided configuration utility along with the OPOS drivers supplied with the RMS software, we got the pole display to work but there are some minor problems. First, the first line message overwrites the second line message when the system is idle, both of which are defined in RMS. For instance, if the first line was set to "Welcome to our store!" and the second line was set to display the date, the pole display would show "Welcome to our store!" on both lin...

Pivot table displayed by day of the week
I would like to create my pivot table displaying data with the date shown as day-of-the-week. That is, I have data collected for a period of months. I want to group my data for several months into Monday, Tuesday, etc. so I see the results for all of the Mondays, Tuesday, etc. in the several month period. Example: For the period Jan 1, 2004 to June 30, 2004: Mon Tue Wed Thu Fri Sat Sun Data1 35 20 46 58 98 109 232 Any suggestions greatly appreciated; can it be done in Pivot Tables? Dan ...

reusing form and display different buttons
I am reusing a form called fClosure and need to open the form from 2 seperate forms and display different buttons(according to where fClosure is opened). On FSplash form I have a button called btnAppClosureMgr I want this to open the fClosure form and display the button called List001 on the fClosure form. On f001ProjectReview form I have a button called btnProjClosePM I want this to open the fClosure form and display the button called List002 on the fClosure form. It's driving me crazy. -- deb I assume you use Docmd.Openform to open fClosure. One of the paramet...

Displaying a binary tree using MFC controls
Hi I'd like to display a binary tree data structure in an MFC-based application. I was toying with the idea of using something similar to a TreeView control, as I would like to make my tree expandable from the root, as the user clicks on the '+' symbols. The key features I would like to add are variable length connections between tree nodes, and to make the tree dynamically expandable (for viewing, not amending) by the user. I've googled for displaying binary trees, but I've not really found a lot of sources on the net about it. I don't have a lot of experience wit...

Windows Vista using IE8.0 page cannot be displayed
The system still gets windows updates but will not display any website. Will not get antivirus or spyware definitions automatically or forced. AIM messenger works also. I tried removing Symantec 360, the removal gets all the way to the end and freezes. I tried restoring back to a previous registry check point no history. I have reset Advanced options in IE8.0 and no change. I want to try all option before starting over with reinstalling Vista. This is a Toshiba laptop and the user has not created restore disks. Connect to the internet when you run the 360 uninstaller. You sh...

Excel Image not displayed when the physical file is N/A
Hello there, I'm having a problem on images that's generated from excel. I'm using the url method to generate the excel file and I'm aware that the images are stored in a physical location and the images won't be able to be displayed if the physical file is not available. I'm able to display the images out when the excel report is generated; however, when we save it as the default xls extension file, and open it in another location, the images are not displayed, as only the physical file path is being stored in the excel file. I've tested it on a c...