Bizzare issue in Excell & Word 2000 When i type the # "1"

In both excel & word (2000) when I type the number "1" it 
immediatly chages to the word "one".  This is a 
particualr pain in excel becausae it can't be used in a 
formual.  This only happens with the number one.  Is this 
some strange setting that I can fix?  Please help.
0
ajsa1009 (1)
2/5/2004 1:29:02 AM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
585 Views

Similar Articles

[PageSpeed] 54

Somebody has probably put an auto-correct entry in the list.  In either Word
or Excel, Tools > Autocorrect and scroll down the list until you find the
entry that shows find "1" and replace with "one".  Select that entry and
press Delete.

Steve


"ajsa1009" <ajsa1009@yahoo.com> wrote in message
news:a35c01c3eb87$6fd46a50$a001280a@phx.gbl...
> In both excel & word (2000) when I type the number "1" it
> immediatly chages to the word "one".  This is a
> particualr pain in excel becausae it can't be used in a
> formual.  This only happens with the number one.  Is this
> some strange setting that I can fix?  Please help.


0
syandl (24)
2/5/2004 2:30:46 AM
Reply:

Similar Artilces:

Wanted: ? UnknownFunction("vbOK") returns 1 in VBE Immediate window
Thanks! George Hi, It is not a function; it is a constant. If you lookup msgbox function and msgbox constants in Help you will find out more about it. The following is a small example of its use where the users selection is returned to a variable. Sub test() Dim Response As Variant Response = MsgBox("Do you want to continue?", vbOKCancel) If Response = vbOK Then MsgBox "User selected OK" 'Insert required code here Else MsgBox "User cancelled." & vbLf & _ "Processing terminated." End If End Sub ...

SP4 Apply Issue - GP 9.0
Hi, While applying SP4 on GP 9.0, we keep getting the following error “ File Not Found …\SQL\Upgrade\949\9.0280\Driver.ini” No errors during executing MSP file. We get this error when we launch GP Utilities and accept the new code prompt. We checked the folder and it does not exist. Any help is appreciated. ...

Issue with Powerpoint 2010 Video Insert
I created a presentation in PP 2010 and inserted a video to a slide. When i try to save the presentation, a compatibility box opens and says that the video will be saved as a picture. Not sure why this is happening. When I open the presentation to view video slide......nothing there? Video is a WMP file. Seems to be conflict with new PP 2010. Any help will be greatly appreciated. Jack Barrett - Director of Development The First Tee of the Palm Beaches 7301 North Haverhill Rd. West Palm Beach, FL 33407 jacklbarrett@yahoo.com www.thefirstteepalmbeaches.org PPT 2010 embed...

Page 1, Page 2, ...is showing up very large in the worksheet.
-- Web Traveler You are in Page Break Preview mode. Go to the View menu and choose 'Normal'. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Tink54" <Tink54@discussions.microsoft.com> wrote in message news:E3ACFA0C-64BB-49CF-8E15-A08770BB7132@microsoft.com... > > -- > Web Traveler You're in Page Break Preview mode. Choose View/Normal. You are in page break view mode, go to view and switch it to normal mode. "Tink54" wrote: > > -- > Web Traveler ...

Excel #16
I work with numbers that have leading zero's. Excel constantly drops the leading zero's is there a way to stop this. Ex type 01111 in a cell and it drops the zero. If I past 01111 into Excel for Access it keeps the zero's but doing some function will then drop the zero again. Format the fields as text "John Stech" <john.stech@khpc.com> wrote in message news:088b01c381de$06d74580$a001280a@phx.gbl... : I work with numbers that have leading zero's. Excel : constantly drops the leading zero's is there a way to stop : this. Ex type 01111 in a cell and it d...

Repeat 6 rows, 1 column on many pages in Excel, 6th row cut off?
Hi, How do I get Excel to not cut off the text in the 6th row when I want to repeat 6 rows and 1 column on multiple pages for printing? ...

Excel Template #12
Good Afternoon, Sorry but I am a little new to templates in Excel. I have created a template, which I would like to add to a toolbar, which I thought I had done although when I click on it, it opens the the actual template where as I want it to open a version of it? Please can anyone help with how I can do this?? Thanks, -- VickyC ------------------------------------------------------------------------ VickyC's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27391 View this thread: http://www.excelforum.com/showthread.php?threadid=490752 It sounds like y...

My 1099 issue
We're on v9. My Acctg Manager want the AP staff to input 1099 TAX info when setting up new vendors and not have it default and be able to 'save' a new vendor to 'Not a 1099 Vendor' as it does now. What I'm looking for is when setting up a new vendor, the user must go to the Vendor Mtce Options screen and be obliged to enter a Tax Type from the pull down. The user will not be able to save a new vendor unless they do so. I've researched this request and cannot find if this can be done or not. Thanks in advance for your help, GP Guy in AZ No, there is not an o...

Running CRM 1.O
Having issues with receiving e-mail to other mail enabled users. Customer's e-mails are coming into the techsupport queue but other techs do not receive the e-mails. We have followed Microsoft documentation, but our mail server is separate from CRM server. We are using Server 2003 help! alfuller@mobilewires.com Sorry running CRM 1.2 "Anthony" wrote: > Having issues with receiving e-mail to other mail enabled users. Customer's > e-mails are coming into the techsupport queue but other techs do not receive > the e-mails. We have followed Microsoft documentati...

Book1 issues
If I open Excel 2003 it opens Book1 (that is normal), then if I make no changes to Book1 and close Excel it asks if I want to save Book1. Normally if you open Book1 and then close Excel it does not ask if you want to save it. Also, if I open Excel 2003 it opens Book1 then I click File, Open and click on an existing .xls file. It keeps Book1 open and you can see this on the taskbar - Book1 and the existing .xls file. Normally if you open Book1 and then open another .xls file it 'closes' Book1 and you don't see it on the taskbar. I have 2 user with Notebooks that have this issu...

excel #132
Column A contains Postcodes numbers, Column B contains Suburbs I would like a formula where Column C contain combined list of of suburbs in a particular Post code separted by comma for example row1- PC 4034 suburb Geebung, Row2- 4034 Aspley,Row3 - 4034 Zillmere Answer required - Post code 4034 - Geebung, Aspley,Zillmere need ur help thanks varun ...

Bizzare issue in Excell & Word 2000 When i type the # "1"
In both excel & word (2000) when I type the number "1" it immediatly chages to the word "one". This is a particualr pain in excel becausae it can't be used in a formual. This only happens with the number one. Is this some strange setting that I can fix? Please help. Somebody has probably put an auto-correct entry in the list. In either Word or Excel, Tools > Autocorrect and scroll down the list until you find the entry that shows find "1" and replace with "one". Select that entry and press Delete. Steve "ajsa1009" <a...

1 becomes 10, how can I stop this
Iv'e been working with basic formulas and worksheets for a short time. Today I opened a saved sheet and found that when I use a number and enter to the next cell, the number gains a zero ie 1 becomes 10. If anyone can help out with this I'd be very grateful. Many thanks DB check for the format of cells. right click on the cell in which 1 turns to 10 select Format cell and see for its format and change it to yor required format according to your data. HerbalDave Wrote: > Iv'e been working with basic formulas and worksheets for a short time. > Today > I opened a sav...

ASP.NET Gets Error "550 5.7.1 Unable to relay" to outside domain
Hello, I am an ASP running my own ISP using SBS 2003 and EX2003, and currently have 25 domains I am hosting. My problem is that my ASP.Net pages cannot send email using System.Web.Mail.SmtpMail to an addressee not already in my domain recipeint policy. This is a problem, as the code should be able to allow anyone in the world to register with the site and then recieve an email message from the code. It seems to me that I should be able to somehow configure the ASP.NET user to have full open relay permissions, or some other clever solution that will not turn me into an open relay, yet st...

Is there anyone using GP v10 and Office 2000 -- Does it work?
Is there anyone using GP v10 and Office 2000 -- Does it work? This is not an officially support combination. Specifically, does Smart List export to Excel 2000, and does the home page work correctly? Thanks, Dan L. On Nov 16, 7:19 pm, Dan Lapp <DanL...@discussions.microsoft.com> wrote: > Is there anyone using GP v10 and Office 2000 -- Does it work? > > This is not an officially support combination. Specifically, does Smart List > export to Excel 2000, and does the home page work correctly? > > Thanks, Dan L. The basic smart list and home page features work. The onl...

Office 2010 Word
I have looked through the list of available discussion groups but am unable to locate one for Office 2010 beta, so I post this here in the hope that someone might direct me to somewhere or someone that can help. Having only just downloaded the beta I have found it to be causing several problems in terms of the speed in which certain things happen - my computer seems much more sluggish than previously with Office 2007. However, I can live with that, but I have also found that when I am using grammar and spell check in Word I get one of two results: 1. No attempt is made by Word...

Only 2000 characters in CRM 1.2?
HI, I have using MS CRM 1.2 and we seem to be limited in the notes section for Phone calls and letters to 2000 characters which we find VERY limiting. Is there any way around this at all? CHeers, Paul Yeah...upgrade! EnigmaPaul@gmail.com schreef: > HI, > > I have using MS CRM 1.2 and we seem to be limited in the notes section > for Phone calls and letters to 2000 characters which we find VERY > limiting. > > Is there any way around this at all? > > CHeers, > > Paul ...

1 Report, Multiple Queries
I am trying to use the same report layout for multiple queries but am having some trouble. The button code is: Private Sub cmdOpenProjectReport_Click() On Error GoTo Err_cmdOpenProjectReport_Click Dim stDocName As String stDocName = "rptStandard" DoCmd.OpenReport stDocName, acPreview Reports!rptStandard.RecordSource = "qryMainTopList" Exit_cmdOpenProjectReport_Click: Exit Sub Err_cmdOpenProjectReport_Click: MsgBox Err.Description Resume Exit_cmdOpenProjectReport_Click End Sub The problem is that when I click the button I get an error messag...

Outlook (2000) opens in 1x1 square
Suddenly today outlook started opening up, on screen, not minimized, but the window was approximately 1x1 inches. I've tried the maximize option and closing it while maximized, I've tried everything I could think of that has worked with Photo Editor or Word. Even checked through the registry but I can't seem to find the setting. Running Outlook 2000 on NT4.0. What if you right click on the shortcut, choose properties and say run...maximized? "Debbie" <anonymous@discussions.microsoft.com> wrote in message news:00bb01c398bd$3c4806a0$a401280a@phx.gbl... >...

Unexpected value in metabase smtpsvc\1\domain
I deleted all the domain keys and the db2mb key as suggested, and when I restarted the exchange services and the smtp service, the metabase was correctly repopulated. I also got one I was not expecting: stirlingadvisory dot com. I do not have a recipient policy for stirlingadvisory. I have an SMTP connector that has stirlingadvisory in the address space. Should I get rid of all my recipient policies? Any comments? Single Exchange 2003 in native mode on Windows Server 2003 (david) "david epsom dot com dot au" <david@epsomdotcomdotau> wrote: >I deleted all the domai...

CRM 1.2
i would like to have all documentation of crm 1.2 (implementation guide, user guide, etc.....) in french version only. is there someone who can help me? Thanks to reply Hei! You can read all information at 1: http://www.microsoft.com/technet/prodtechnol/mscrm/mscrm12/default.mspx 2: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/CrmSdk/htm/default.asp Best Regards, Olav Click Soft "help" wrote: > i would like to have all documentation of crm 1.2 (implementation guide, user > guide, etc.....) in french version only. > > is there someone who ...

Excel 2007 Sheet with rows more than 15000
While working with excel sheets having rows more than 15000 lines, sometimes I observe that the processing is slowed down if data more than 15000 lines is selected. However the work is takes very less time if number of rows selected are less than say 12000. I have 2GB RAM, Can someone help me on this issue? I'm not sure what type of help you're looking for. Excel 2007 is what it is, and you either need to select more than 15,000 rows or you don't. Other than purchasing and installing more RAM on the computer or buying a newer, faster computer with tons of RAM I'm not s...

change a number (100) to word (i.e Hundred)
Dears, Is there a function or a way to change automatically a number typed in a cell (eg: 100) as in tex format? (i.e Hundred)? Kind regards, Abdulssalam CH Take a look at http://www.xldynamic.com/source/xld.xlFAQ0004.html Excel FAQs - Convert Numbers To Text -- HTH RP (remove nothere from the email address if mailing direct) "CHA Salam" <CHA Salam@discussions.microsoft.com> wrote in message news:DE427447-1B13-4C64-812A-CF7AF5213EE1@microsoft.com... > Dears, Is there a function or a way to change automatically a number typed > in a cell (eg: 100) as in tex for...

GP10 on SQL 2000 MSDE on an XP Machine
Hello -- I am dealing with a client that is running the most wacked out configuration I have ever witnessed. He has 5 instances of SQL Server running on his XP Machine ... all SQL Server 2000 (2 developer editions, 3 MSDE) ... He was running GP 8 and GP 9 side by side. Wooof! Then he tries to upgrade GP9 to GP10 and screws up somehow, then decides to do a fresh install GP10 without switching ODBC connections to one of his other SQL Server instances. I have pretty much got him back to working ... He is running off one of MSDE instances. He is only up to SP3. I was trying to upgrade him to SP4...

How do I make a Header stop printing on page 1 only?
Try this CB http://www.rondebruin.nl/print.htm#Header -- Regards Ron de Bruin http://www.rondebruin.nl "CB" <CB@discussions.microsoft.com> wrote in message news:14D5CA97-518E-4A45-BFEA-E1DB8F807DFD@microsoft.com... > Ron- Looking at your helpful code I wondered whether you have to specify the "To" parameter. It doesn't look like it, as least this prints page 2 and everything beyond it in Excel 2003 for me: Sub Test() With ActiveSheet.PageSetup .RightHeader = "Your Header info" ActiveSheet.PrintOut From:=1, To:=1 ...