A bug in excel

Hi,

I found a bug in excel 2000.  I tried to replace all ? with 0 in a column.
It replaced all the cells to be 0, even the cells with other values that
were not ?.

Chris


0
yma (2)
9/7/2003 7:26:47 PM
excel.misc 78881 articles. 5 followers. Follow

4 Replies
279 Views

Similar Articles

[PageSpeed] 9

? is a wild card.  It's  used to represent any character.

Try replacing ~? with 0.  The tilde says to treat the question mark as a
question mark.

(Same kind of thing with asterisk (*).)

yma wrote:
> 
> Hi,
> 
> I found a bug in excel 2000.  I tried to replace all ? with 0 in a column.
> It replaced all the cells to be 0, even the cells with other values that
> were not ?.
> 
> Chris

-- 

Dave Peterson
ec35720@msn.com
0
ec35720 (10082)
9/7/2003 7:33:00 PM
Why is that a bug?  It has just done exactly what you asked it to do.  :-)

? is a wildcard representing any character, so asking it to replace ? is the same as asking it to
replace every character.

Precede the ? with a ~ in the 'find what' box of the Edit / Replace dialog box.

--
Regards
           Ken.......................    Microsoft MVP - Excel
                   Sys Spec - Win XP Pro /  XL2K & XLXP

----------------------------------------------------------------------------
  Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



"yma" <yma@pacbell.net> wrote in message news:uBGyWYXdDHA.3992@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> I found a bug in excel 2000.  I tried to replace all ? with 0 in a column.
> It replaced all the cells to be 0, even the cells with other values that
> were not ?.
>
> Chris
>
>


0
ken.wright (2489)
9/7/2003 7:33:09 PM
Hi,

Thank you both a lot.  It is not a bug.  It is my misunderstanding.

Chris

"yma" <yma@pacbell.net> wrote in message
news:uBGyWYXdDHA.3992@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> I found a bug in excel 2000.  I tried to replace all ? with 0 in a column.
> It replaced all the cells to be 0, even the cells with other values that
> were not ?.
>
> Chris
>
>


0
yma (2)
9/7/2003 9:05:38 PM
LOL - No problem - We all have a lot of those.

--
Regards
           Ken.......................    Microsoft MVP - Excel
                   Sys Spec - Win XP Pro /  XL2K & XLXP

----------------------------------------------------------------------------
  Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



"yma" <yma@pacbell.net> wrote in message news:ugY#lPYdDHA.3520@tk2msftngp13.phx.gbl...
> Hi,
>
> Thank you both a lot.  It is not a bug.  It is my misunderstanding.
>
> Chris
>
> "yma" <yma@pacbell.net> wrote in message
> news:uBGyWYXdDHA.3992@TK2MSFTNGP11.phx.gbl...
> > Hi,
> >
> > I found a bug in excel 2000.  I tried to replace all ? with 0 in a column.
> > It replaced all the cells to be 0, even the cells with other values that
> > were not ?.
> >
> > Chris
> >
> >
>
>


0
ken.wright (2489)
9/8/2003 6:05:02 AM
Reply:

Similar Artilces:

drawing box plots with excel
I have different sets of data and would like to draw box plots (Minimum lower quartile, medium, upper quartile, maximum) to present them. I there any way to do this with excel or do you know another program that might help? Many thanks -- Message posted from http://www.ExcelForum.com do you want to actually plot the box or do u want excel to work out the results for the upper quartile ect? MVP Jon Peltier has some instruction on his site for creating box and whisker charts: http://www.peltiertech.com/Excel/Charts/ComboCharts.html#B oxWhisker HTH Jason Atlanta, GA >-----Original ...

How do i break a link to another excel workbook?
Try this, andreas: http://www.officearticles.com/excel/removing_links_in_microsoft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "andreas" <andreas@discussions.microsoft.com> wrote in message news:58E07650-03A1-4A97-947A-7AF11DB8CEA0@microsoft.com... > "Anne Troy" <ng@officearticles.com> wrote in message news:c898$42ccca6b$97c5108d$5483@allthenewsgroups.com... > Try this, andreas: > http://www.officearticles.com/excel/removing_links_in_microsoft_excel.htm > ******************* Or even better, get F...

namespaces and protected static members VC .NET bug?
I found bug when use namespaces in mfc application. When I wrote DECLARE_MESSAGE_MAP/BEGIN_MESSAGE_MAP in base (CDialog-derived) class A and in class B : public A (A and B in different namespaces). I narrowed this problem to simple peace of code: class A { protected: static int f; static int *p; public: A() {} ~A() {} }; int A::f = 1; int *A::p = NULL; namespace some { class A : public ::A { static int f; static int *p; public: A() {} ~A() {} }; int A::f = 2; int *A::p = &::A::f; // this line produces error } This code does not work, VC compiller said: error C2248...

Excel auto backup
it only happens in that excel 2007 file. when it is saved, it created a backup copy in the same directory. further saved, it overwrites the backup copy the backup copy come out even i disable the autosave function in option. i checked out that there is no vba or macro in that Excel. it should not be autosave function because it happens only in save action, not in time interval. grateful for any advice. thanks. tony Hi, I'm not sure what you are asking but you can turn off the auto backup option by choosing Office Button, Save As, open the Tools drop down and choose General ...

Auto Filter
When using the filter only the first 1000 unique entries in a list will appear when you click on the arrow. I have more than 1000 unique entries [ie. company names] that I would like to see when filtering. Is there any way of being able to accomplish this? Hi you may have a look at http://www.contextures.com/xlautofilter02.html#Limits for a workaround Frank Gail wrote: > When using the filter only the first 1000 unique entries in a list > will appear when you click on the arrow. I have more than 1000 > unique entries [ie. company names] that I would like to see when > filterin...

Can I Import a pocket Excel (*.pxl) spreadsheet into Excel 2000
Is it possible to import a pocket excel (*.pxl) spreadsheet into Excel 2000 desktop, without using Active Sync ...

how do i use excel to refer to outlook?
I'm trying to pull contact information and other information from outlook and use in excel Try File-->Import and Export from Outlook. ************ Anne Troy www.OfficeArticles.com "chip_pyp" <chip_pyp@discussions.microsoft.com> wrote in message news:14CF4B2D-A361-4FA6-B41A-D965EA40D8BB@microsoft.com... > I'm trying to pull contact information and other information from outlook > and > use in excel ...

EXCEL AND ACT!
HOW DO I MERGE EXCEL AND ACT FILES? I WANT TO MERGE AN EXCEL FILE INTO MY ACT! PROGRAM Save your EXCEL document as a text (tab delimited) file. Open Act! and import data then select tab delimited you will be given the option of directing the information in your file to the appropriate fields in ACT! If your spread sheat heading match Act this is nearly automatic "EXCEL AND ACT!" wrote: > HOW DO I MERGE EXCEL AND ACT FILES? I WANT TO MERGE AN EXCEL FILE INTO MY > ACT! PROGRAM ACT! should be able to read an excel file directly, provided you have the data organized in ...

excel 03 to 07 printing
running trial version. save 03 workbook as 07. 03 workbook came from new computer with 07 on it. saving 03 as 07 on computer that is running 07 trial. now either version will print nothing--page is blank. On Wed, 9 Jan 2008 15:22:36 -0800, harleyman <harleyman@discussions.microsoft.com> wrote: >running trial version. >save 03 workbook as 07. >03 workbook came from new computer with 07 on it. >saving 03 as 07 on computer that is running 07 trial. >now either version will print nothing--page is blank. Please repost your question in an Excel newsgroup. The webpage can be c...

Creating Multiple Excel Charts
Is there any easy way to create charts in excel? I have 24 graphs (on one page) to create and show actual and budget data on a line graph, the actual and budget data are on separate tabs. It is for a rolling 24 months time frame, and I have to have similar graphs for four locations. Is there an easy way of doing this? I tried doing the name ranges, but this will require too many named ranges. Thanks. Do you need 24(x 4?) or will one that you can change the month to display. More info -- Don Guillett SalesAid Software dguillett1@austin.rr.com "houstonguy" <jerrymoon1@yah...

Excel 12: Data Entry Form?
Help! I'm here at work and I've just upgraded from Microsoft Office 2003 to Microsoft Office 12 pre-release edition. For the life of me, I can't figure out how to open a data entry form in Excel 12! In previous versions of Excel it was easy --- just click on Tools->Form. But in the Tools grouping in the new Excel there doesn't seem to be any comparable thing. Can anyone help me? Maybe it's the dementia kicking in, but I need to enter a whole lot of data today into my spreadsheet and my boss is going to have my head, etc... Thanks! Tim I have it at home so I...

BUG? Outlook 2003 Not Responding
Hi all, I'm currently running Outlook 2003 (11.5608.5606) along with Active Sync 3.7 (Build 3083). I have the *Hide When Minimized* option set Outlook (thanks MS!) Since my upgrade, I've noticed the following behaviors: When my pocket-pc is disconnected/off: If I *minimize* Outlook, it hides itself in the system tray, and can (almost) always be restored. If I *close* Outlook closes, and can be restarted. When my pocket-pc is connected/on: If I *minimize* Outlook, it hides itself in the system tray, and can (almost) always be restored. However if I *close* Outlook Outlook minimizes ...

Spellchecking in Excel???
I need to translate Japanese into English and German in Excel. The first column is the source language (Japanese), and the two other columns are reserved for English and German. I use the US version of Win XP as well as MS Word 2000 (Office) and MS Proofing Tools. When I am in MS Word, the software recognizes the prevailing language and spellchecks properly. However, in Excel the English spellchecker kicks in, although I highlighted the German column before running the check. The German keyboard had also been selected. How can I do what I want to do? Thanks in advance, S.R. ______________...

Exporting addresses from excel to outlook
I have addresses in excel and would like to export into outlook. I have no idea how to achieve this. Can anyone help??? Hi Linda. In Outlook, click on File and then Import/Export and follow the directions of the dialog box. You will be asked to specifiy the file type - Excel - and then browse to the file. Select Contacts as the outlook folder to import into. You will also be required to map the fields in your Excel file with those in Outlook. Make sure you have a field heading for each Column in Row 1. You could also add a Category column in the Excel file if you want to group ...

Transactions By Category Report Bug (Money 2005)
All, I'm experiencing a problem that I can't seem to work around and I hope somebody can help me out. I ran the transaction by category report and selected category A. I then went to the category setup screen and moved category A into B. I then went back to the transactions by category report and this time it won't open. Instead, it acts like it's going to open, but then immediately reverts back to the report menu screen. I'm pretty sure it's doing that because the last selected category the report ran was for category A and that category doesn't exist anymore...

Excel
I work for an international company and am constantly faced wit spreadsheets of financial data supplied in one currency that must b totally converted to another. Duplicating the spreadsheet and building a formula in each cell tha refers to a "seed" cell with the conversion rate is extremely tim consuming, and must be duplicated each time a new original sheet i received. As far as I know, the Euro conversion function only works for th companies actually involved in the Euro community, and can't be use for dollars to Euros, or Pesos to Pounds. Conceptually, I'm looking for a...

Can't format cell color/text color in Office Excel 2003 in files .
Just loaded Office 2003 and now cannot change cell color or text color in Excel sheet created in Office 2000. Cells are not protected or locked and file is not read only. Other alterations such as font changes are possible. Any ideas? Thanks! ...

OL2003 Signature Bug?
I have four pop-mail accounts in a single profile. I'll call the Accounts A, B, C, and D. "A" is the default account. In OL2003, you are able to create a different signature for each account. I have created "New Message" and "Reply-to/Forward Message" signatures for two of the accounts (A and C). When creating a new message, the signature for A appears correctly by default. If I switch the "send from" account to C, the signature for C replaces the signature for A. This is expected. If instead, I switch to accounts B or D, the signature...

Secure File Server For Excel Files
How can i set a secure server for excel file? I would like for multiable users to be able to open, edit, and save files via the internet. log into server to do so. ...

Import excel into publisher
It would be beneficial, if Publisher had the capibilities to import Excel spreadsheets to keep data up-to-date. I read that it is NOT possible, or is there something I missed? Import excel into publisher wrote: > It would be beneficial, if Publisher had the capibilities to import Excel > spreadsheets to keep data up-to-date. I read that it is NOT possible, or is > there something I missed? You can Mail Merge from Excel spreadsheets, and you can insert an Excel sheet as an OLE object. Does that not cut the mustard? -- Ed Bennett - MVP Microsoft Publisher http://ed.mvps.org ...

Is it possible to make Labels from Excel?
I'm not sure if it can be done, our database is strickly Excel and I'd like to make labels from the Names & addresses we have listed on there. Can it be done stricktly from excel? Hi Julia, Not an easy task without a lot of programming. But you can use an Excel database as the source file for Word 'mail-merge' and hence make labels. Bernard "Julia" <anonymous@discussions.microsoft.com> wrote in message news:001501c3a3b8$08937fa0$a301280a@phx.gbl... > I'm not sure if it can be done, our database is strickly > Excel and I'd like to make la...

Is this a bug or not?
I replied to an email that was archived in Outlook 2007. The 'sent' copy was placed in the archived sent folder instead of the one in my personal folders. Is this normal or a bug? Is there anyway that I configure responses to archived 'mails to be put in the current sent folder? TIA. Cheers, Guy ** Stress - the condition brought about by having to ** resist the temptation to beat the living daylights ** out of someone who richly deserves it. "Dr Teeth" wrote in message news:db8si3lpuejhnpm3luacpu2rkkaef66stt@4ax.com... > I replied to an email that was archiv...

How to tell Excel to insert cells and shift down from Access
Hi all, I have Access 2003. I am trying to tell Excel to insert cells and shift cells down from Access, with this line of code: oWksh.Cells.Insert Shift:=xlDown But Access does not like that line. It gave me run-time error 1004. I know if has to do with the part Shift:=xlDown Can you suggestion what I can do? Thank you in advance, Ben "Ben" <Ben@NoSpam.com> wrote in message news:eSZuzcDpKHA.1892@TK2MSFTNGP02.phx.gbl... > Hi all, > > I have Access 2003. I am trying to tell Excel to insert cells and shift > cells down from Access,...

75seconds to load excel files
all of a sudden my Excel (and Word) files take about 75 seconds to load after the application has loaded. I cannot find any reason but there again I am a novice. Can anyone advise? Thanks for your help in anticipation bri -- bri ------------------------------------------------------------------------ bri's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27704 View this thread: http://www.excelforum.com/showthread.php?threadid=478584 http://www.officearticles.com/word/microsoft_word_takes_a_long_time_to_open.htm ************ Anne Troy www.OfficeArticles.com...

Money 2006 net worth bug
I have noticed that one of my net worth over time favorite reports refuses to load. If I watch the CPU, it appears that $ is in an infinite loop with the load bouncing back and forth between 50 and 80%. But the really amusing thing is this: during the loop if I select "custom date", change either the start or stop date (move either to a new date, or just touch one - change a date and move it back) and select the APPLY button, the load will converge. If you select the OK button, the load will not converge. I have saved a net worth report that converges and attempted to reload...