 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / October 2006"Magic" Formula
I have several cells on a worksheet that "magically" create a formula when I enter data into the cell. I've deleted the contents of the cell, assigned a variety of formats, etc, to no avail. But, if I copy the contents of another cell and paste it into these cells things work just fine. Totally confused. Thanks in advance for help  SignatureBill Gable right click on the worksheet tab>view code to see if there is a worksheet_change event. SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com >I have several cells on a worksheet that "magically" create a formula when >I [quoted text clipped - 5 lines] > confused. > Thanks in advance for help Don: WHile I am not familiar with you're suggestion, when I foolow your instructions I open a VB page that contains no code SignatureBill Gable > right click on the worksheet tab>view code to see if there is a > worksheet_change event. [quoted text clipped - 8 lines] > > confused. > > Thanks in advance for help OK. Now look in the ThisWorkbook module to see if there is code there that is doing it. SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > Don: > [quoted text clipped - 15 lines] >> > confused. >> > Thanks in advance for help there isn't any code in the large right-hand panel either SignatureBill Gable > OK. Now look in the ThisWorkbook module to see if there is code there that > is doing it. [quoted text clipped - 18 lines] > >> > confused. > >> > Thanks in advance for help I will be going out shortly but send the workbook and I will take a look. SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > there isn't any code in the large right-hand panel either > [quoted text clipped - 22 lines] >> >> > confused. >> >> > Thanks in advance for help How about an example of what is entered in the cell, and what formula is magically created. > there isn't any code in the large right-hand panel either > [quoted text clipped - 22 lines] >> >> > confused. >> >> > Thanks in advance for help Prior to entering anything, the cell is blank and formatted as General, and nothing shows in the formula bar. I enter the following "11/21/2000", and the cell displays "0.0002619" and the formual bar displays "=11/21/2000" SignatureBill Gable > How about an example of what is entered in the cell, and what formula is > magically created. [quoted text clipped - 25 lines] > >> >> > confused. > >> >> > Thanks in advance for help Goto Tools-Options-Transition. Uncheck Transition formula entry. Regards, Paul > Prior to entering anything, the cell is blank and formatted as General, > and [quoted text clipped - 33 lines] >> >> >> > confused. >> >> >> > Thanks in advance for help Well spotted Paul!! > Goto Tools-Options-Transition. > Uncheck Transition formula entry SignatureRegards Roger Govier > Goto Tools-Options-Transition. > Uncheck Transition formula entry. [quoted text clipped - 46 lines] >>> >> >> > confused. >>> >> >> > Thanks in advance for help Paul: thanks, that did it. Never even knew that checkbox existed, let alone understand what it does. Since I created this spreadsheet from a query in Access, do you know if that process turns on this option or somehow has something to do with this? Thanks again! SignatureBill Gable > Goto Tools-Options-Transition. > Uncheck Transition formula entry. [quoted text clipped - 39 lines] > >> >> >> > confused. > >> >> >> > Thanks in advance for help This might help explain a few things. http://support.microsoft.com/kb/213953 Regards, Paul > Paul: thanks, that did it. Never even knew that checkbox existed, let > alone [quoted text clipped - 53 lines] >> >> >> >> > confused. >> >> >> >> > Thanks in advance for help Hi Don't enter the = sign =11/21/2000 is telling Excel to divide 11 by 21 then divide that by 2000 and it quite correctly shows the result as 0.0002619 If your Regional settings are for mm/dd/yyyy than entering 11/21/2000 will give you a date of 21 Nov 2000 but if the cell is formatted General that will be shown as 36851 being the number of days after Jan 00 1900. Format the cell with your preferred date format, and all should be well. SignatureRegards Roger Govier > Prior to entering anything, the cell is blank and formatted as > General, and [quoted text clipped - 39 lines] >> >> >> > confused. >> >> >> > Thanks in advance for help Roger: If you look closely at my previous response, you'll see that I AM NOT entering the "=" sign - I'm just entering the date and Excel is entering the "=" SignatureBill Gable > Hi > [quoted text clipped - 51 lines] > >> >> >> > confused. > >> >> >> > Thanks in advance for help |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.