Leading zero #2

I format a column to text and type a series of items, each of which have a
leading zero.  So far so good.  If I have to do a mass edit on these items,
using find & replace (Ctrl+H) it automatically drops the leading zero.

Example:  Column A contains the following:
020003
020004
020005

I need to change these to 030003, 030004 & 030005
I replace 020 with 030 and now Column A looks like this:

30003
30004
30005

How do I keep my leading zeros?

Rdd


0
dieckmann (6)
7/18/2003 3:46:10 PM
excel.misc 78881 articles. 5 followers. Follow

3 Replies
596 Views

Similar Articles

[PageSpeed] 42

Robert

You could format the cell to Number 000000. This would keep the leading
zero.

Andy
"Robert Dieckmann" <dieckmann@mfsyork.com> wrote in message
news:vhg5jvs0nic16e@corp.supernews.com...
> I format a column to text and type a series of items, each of which have a
> leading zero.  So far so good.  If I have to do a mass edit on these
items,
> using find & replace (Ctrl+H) it automatically drops the leading zero.
>
> Example:  Column A contains the following:
> 020003
> 020004
> 020005
>
> I need to change these to 030003, 030004 & 030005
> I replace 020 with 030 and now Column A looks like this:
>
> 30003
> 30004
> 30005
>
> How do I keep my leading zeros?
>
> Rdd
>
>


0
andy9118 (66)
7/18/2003 4:05:21 PM
"Robert Dieckmann" <dieckmann@mfsyork.com> wrote in message
news:vhg5jvs0nic16e@corp.supernews.com...
> I format a column to text and type a series of items, each of which have a
> leading zero.  So far so good.  If I have to do a mass edit on these
items,
> using find & replace (Ctrl+H) it automatically drops the leading zero.
>
> Example:  Column A contains the following:
> 020003
> 020004
> 020005
>
> I need to change these to 030003, 030004 & 030005
> I replace 020 with 030 and now Column A looks like this:
>
> 30003
> 30004
> 30005
>
> How do I keep my leading zeros?
>
> Rdd
>
>

Replace with '030 instead of just 030.
(That's an apostrophe before the 030.)


0
Anon
7/18/2003 4:11:39 PM
How about changing
020
to
'030
(leading apostrophe)



Robert Dieckmann wrote:
> 
> I format a column to text and type a series of items, each of which have a
> leading zero.  So far so good.  If I have to do a mass edit on these items,
> using find & replace (Ctrl+H) it automatically drops the leading zero.
> 
> Example:  Column A contains the following:
> 020003
> 020004
> 020005
> 
> I need to change these to 030003, 030004 & 030005
> I replace 020 with 030 and now Column A looks like this:
> 
> 30003
> 30004
> 30005
> 
> How do I keep my leading zeros?
> 
> Rdd

-- 

Dave Peterson
ec35720@msn.com
0
ec35720 (10082)
7/18/2003 10:54:54 PM
Reply:

Similar Artilces:

Chinese antique #2
Q2hpbmVzZSBhbnRpcXVlCndvcmxkIGZpcnN0LCB0aGUgYW50aXF1ZSBjaGluYXdhcmUgc2VyaWVz IHBsZWFzZSB3YXRjaCEKRW50aXJlIGZpZGVsaXR5IDEwMCUgQW50aXF1ZSAoMTkxMi0xOTQ5KSBS ZXB1YmxpYyBvZiBDaGluYSBwb3JjZWxhaW4KdGVhcG90IDg4OCBjaGluYXdhcmVzIDQwMCBwbGVh c2Ugd2F0Y2hpbmchCldlYnNpdGUgaHR0cDovL3d3dy54ang1ODguY29tCkUtbWFpbCB4anhfNTg4 QHRvbS5jb20KQ2l0eSBTaGVuZ3pob3UgWmhlamlhbmcgQ2hpbmEKCsirx/LOqNK7oaK5xbattMnG 98+1wdDD8bn6tMmy6Lr4ODg4sNHH67nbyc2joQrIq8fyzqjSu6GiyKuxo9XmucW2rbTJxvfPtcHQ w/G5+rS/ytbWtLTJsui6+Dg4OLDRoaK0ycb3NDAwvP7H67nbyc2howq5xdLV0Pm5xbatytWy2Nau trwKzfjVvqO6aHR0cDovL3d3dy54ang1ODguY29tCrXn08qjunhqeF81ODhAd...

Cash Sales Entry #2
How to do a cash sales entry? You mean a cash-basis accounting type of entry or a sales transaction where you are receiving cash (as opposed to check or credit card)? New User wrote: > How to do a cash sales entry? ...

Save email as word doc #2
Does anyone know how to save a Email message to a word document. When tring to select "as save type" word document, in the save as documents screen there is no choice to save as word doc. Is there a way to activate it in outlook 2003, the option was avaliable in earlier versions. You should be able to do this when you set Word as your e-mail editor and then reply on the message. -- Robert Sparnaaij [MVP-Outlook] www.howto-outlook.com Tips of the month: -Backup and Restore -Create an Office XP CD slipstreamed with Service Pack 3 ----- "Tec" <anonymous@discussio...

Converting Lead Notes and Activies information into Opportunity re
The Lead Activities (phone calls, emails, task, appointments, fax, letter) and the Notes created while working on a Lead do not "convert" into the Opportunity. To get this information, you have to go to Closed Leads or drill down through the Originating Lead link. I've read that this will be in 2.0 but in the meantime, can anyone suggest a simple workaround. I would also like to hear about the best way to do this, simple or note. If I create new fields in the Lead form and map them to new fields in the opportunity form, the activity functionality is reduced to that of ...

Diagram show blank as zero value when based on a formula
When a chart is based on a formula e.g. =IF(A1=0;"";A1*B1) then the chart will show the blank value "" as zero even if you whant to plot gaps or plot the empty cell interpolated. Yes, I know Excel say empty cell and the cell is not empty when there is a formula. Is there anybody who have found a "work around"? I often have formulas that generate zero in the result but I want to plot the result as if it was empty. I found the reply myself in a question from another user similar to this issue. I will use NA() instead of "" Thank you that works! &q...

Lead to Product and Lead to Competitor relationships
While browsing MS CRM logical DB Diagrams (http://www.microsoft.com/ dynamics/crm/using/sdk/DBDiagrams.mspx) for Sales Entities, I have found many-to-many relationship between Lead and Competitor entities. In SQL Server I made a diagram with the following tables: LeadBase, ProductBase and CompetitorBase and then I added tables LeadCompetitors, LeadProduct (these tables contain no data in my case). You can see my diagram below. I saw many-to-many relationships between Lead & Product and Lead & Competitor. As far as I understand, these relationships must support functionality for adding ...

Microsoft Outlook #2
I do not know how to backup Outlook. I would appreciate it if someone could explain how. I am worried that I could lose all of the contact and calendar data. ...

help with matching if #2
The formula worked very well. As you can see I am totally a noob to excel. And I have another noo problem needed to be solve. can someone please help me once more. Quetion #2: per say, I have a table of data, and I would like to exce to return the matching values from the table to a2. for example: [ ]|Y1 |Y2| Y3| X1|.54|.65|.67| X2|.56|.67|.89| cell A1=Y1 cell A2=X1 A4 will return the matching values from y1,x1=.54 Thx for the help everyone. Highly Appreciated -- augustu ----------------------------------------------------------------------- augustus's Profile: http://www.excelfor...

how to Sum last 10 values of a dynamic column excluding zero
hi, i have this formula =SUM(OFFSET(P2,MATCH(1E+30,P:P)-1,0,-10,1)) which sums the last ten values in column P, i was hoping someone could amend it slightly for me. As column P is dependent on other entries the entire column has 0 in it which makes this formula ineffective, i can't put an IF formula into column P because then that wrecks other formulas that need column P, so i need to work in a way of excluding zero into the forumla above. Also, the formula does not work until there are ten values in the column, is there any way to make it work and count the values up until ...

Printing labels #2
I have created a holiday gift label in Publisher. I do not however need to print a full page for each relative. Can anyone help direct how to print a specific number of labels as opposed to a full page. What version of Publisher are you using??? -- This is the ugly way of doing it. I use Publisher 2000. I take a piece of 8�"x11" (in A4 country, use A4) and some Scotch Temp tape and cover the labels I don't need. -- Don -------- Vancouver, USA - One of the great cities in one of the 45+ countries in America! "Ed Heff" <edaheff@comcast.net> wrote i...

default file locations #2
Application: Excel Version: 97 We have a shared file out on our server that sales accesses daily. On one computer when saving, it wants to save to his "my documents" folder on his local computer and not to the original location on the network. This just started happening on his computer. If I go to another computer and open and save it, it saves it to the correct network location. Any help would be greatly appreciated. Just a guess, but are you sure that the user is hitting File|Save and not File|SaveAs. In xl97, file|saveAs will want to save to the default folder--not the folder ...

shapes #2
I closed the shapes toolbar (perhaps its called a "stencil"?). I can't get it to come back. It was located at the bottom of the main window. I closed it intentionally to maximize the main window size, but i can't seem to figure out how to get it back. I can get Shapes Windows to appear behind or to the left of the main window, but I can't get them to adhere to the bottom of the window (like toolbars do). Any suggestions? What version of Visio are you using? With 2003 if you grab the "Shapes" window by the title and drag it over your document to the v...

Missing mail folder #2
HI Today my machine did not start properly and I seem to have lost a mail folder in Outlook 2003 I have used the Inbox Repair Tool and it did find errors, but hasn't repaired the missing mail folder. Its not in recycle bin Im sure I've not deleted it and I need the emails. Help please. yar <newspost@btconnect.com> wrote: > Today my machine did not start properly and I seem to have lost a mail > folder in Outlook 2003 I have used the Inbox Repair Tool and it did > find errors, but hasn't repaired the missing mail folder. Its not in > recycle bin Im sure I&...

Keeping one of 2 cells always zero
Hi all of you, I have such a requirement. There are 2 cells in which the user ca input values. However, one of the two cells must always be zero fo valid inputs. Is there any way to do this? I was thinking of setting other cell to zero when user enters value i one cell or prohibit user from entering value in a cell till the othe is made zero but I don't seem to figure out how to do this. Is a macro the only way out (trapping a worksheet change?)? Is i possible to use someother functionality like data validation. I woul also like to impose restrictions on the non-zero cell of values betw...

XSL question #2
I have an sample xml below. I want to do a distinct on the code node and the programDescription. I want the output to be like in a tree structure. So i would like to have PRG004 >Crazy Training 2> MAT01 PHS101 Any ideas it musn't be in a tree but it could be in a table structure Thanks <?xml version="1.0" standalone="yes"?> <?xml-stylesheet type="text/xsl" href="email.xsl"?> <NewDataSet> <ProgramDetail> <Code>PRG004</Code> <programDescription&g...

Receiving e-mail #2
Hi, I was wondering if anyone could help me with this. On my outlook at work. I can send e-mails to those outside the company but cannot receive e-mails from outside. Any advise would be great. Thanks, On Sun, 8 Aug 2004 22:02:39 -0700, "Crissy" <anonymous@discussions.microsoft.com> wrote: >Hi, >I was wondering if anyone could help me with this. On my >outlook at work. I can send e-mails to those outside the >company but cannot receive e-mails from outside. >Any advise would be great. > You need to ask your System Administrator at work if this is po...

MAINTAIN pst files #2
>i know that there are 2 utilities that come with office that can scan and >do > something else to my pst file. > > i have outlook 2003 and have no idea where i might find those files. > > can anyone lead me to the right place? > > Thank You > windows xp > ...

CSV File
I am opening a common delimted file in Excel and formating 2 fields as "text" to retain leading zeros. They appear correctly in Excel. I then need to save as a "csv" file and retain the leading zeros. How can I do this? The zero's always drop off in the csv file when retrieved again in excel. TIA hi, do you need to save the csv every time, if you save I agree it will remove the zeros. There is no perfect solution to this but if your file format is standard, you may consider preparing a excel template with the repeate, concencanate and left and right formul...

Default Font #2
In Outlook 2003, I find the font too small. Where do I go to change the default font of the messages I create? -- Paul Ingram DNS SYSTEMS LIMITED (902) 488-3166 Web: www.dnssystemsltd.com Email: dnssystems@ns.sympatico.ca Paul: Try Tools > Options > Mail Format - Fonts HTH Steve "Paul Ingram" <pingramnet@hotmail.com> wrote in message news:W5l%c.123663$Np3.5283800@ursa-nb00s0.nbnet.nb.ca... > In Outlook 2003, I find the font too small. > Where do I go to change the default font of the messages I create? > > -- > Paul Ingram > DNS SYSTEMS LIMITED >...

Watermark in Excel #2
Can a watermark be added to an Excel worksheet? See: http://www.xldynamic.com/source/xld.xlFAQ0005.html HTH Jason Atlanta, GA >-----Original Message----- >Can a watermark be added to an Excel worksheet? >. > ...

My Custom Line-Column 2 axes Chart dsn't work with +6sets of cells
I created a custom Line-Column 2 axes chart with 6 columns and it worked fine, showing two different Y axis. Then I tried to do the exact same process with a larger data set, with 10 rows again, but this time 12 columns, and it doensn't work - it repeats the 12 columns twice, instead of recognizing that I want the 2 sets of 12 on top of one another, like 2 layers, each with a different Y axis. Any ideas on how to avoid this? I think it may be a flaw in the software because, literally, when I delete half the cells and run the same process, it works... it just doen'st seem t o kno...

Fill leading zeros
I have a SELECT statement that I want to fill leading zeros in one column and trailing blanks in another column up to xx characters. For example SELECT CAST(EmployeeNumber AS varchar(8)) If the EmployeeNumber is 1234 I want to output 00001234 SELECT CAST(LastName AS varchar(15)) If the LastName is SMITH I want to output SMITHxxxxxxxxxx where x = space Could this be done by casting a CHAR(15)? Thanks. -- David DavidC wrote: > SELECT CAST(EmployeeNumber AS varchar(8)) > If the EmployeeNumber is 1234 I want to output 00001234 SELECT RIGHT('00000000' + CAS...

Generate Leads/Accounts/Cases from a public website?
Greetings all, My employer asked me to investigate using a public .Net website to help generate information to be used in CRM. Specifically, he'd like our website to have webforms that, when filled out and submitted, would generate leads, accounts, or cases depending on what our needs are (I suspect generating leads would suffice for now). Can anyone point me in the right direction on how to accomplish this? I've found it difficult to find information online concerning this. We're currently using CRM 3.0 although I'd be interested to know what differences would be in...

Lead Number
Hi, I want to count the number of lead in the database with reports, but don't known how to do ? If anyone has an idea ? Thanks Bernard You won't be able to accomplish this by using the Report Wizard. You need to use the SRS BI tool for Visual Studio. HTH SS "info@alsaceformation.fr" wrote: > Hi, > > I want to count the number of lead in the database with reports, but > don't known how to do ? If anyone has an idea ? > > Thanks > Bernard > On 14 ao=FBt, 16:01, SS <S...@discussions.microsoft.com> wrote: > You won't be able t...

zero value
How do you add a zero in front of a number in excel without it disappearing? Precede it with an apostrophe or use a custom format like 0000 which would display 0123 if you enter 123 in the cell -- Regards, Peo Sjoblom "Jimmy" <Jimmy@discussions.microsoft.com> wrote in message news:7F27069C-37B5-48BC-810C-9CA8A2182761@microsoft.com... > How do you add a zero in front of a number in excel without it disappearing? >-----Original Message----- >How do you add a zero in front of a number in excel without it disappearing? >. > if the number remains constant ...