Formula not being stored any more
Recently, Excel has stopped storing certain formulae in
the formula bar. For example, if I type in say "=3*1/10"
Excel will store "=0.3" in the formula bar. This is most
inconvenient as I want to be able to tell what the
constituent parts of the calculation are. It never used
to do this so have I accidentally set an option on
somewhere? How do I turn it off again?
I couldn't duplicate this.
If I typed:
and hit F9 (calculate)--not enter
You're not getting close to the F9 key (with only portions of your formula
selected? (Yeah, I did...First non-blank row in WS after hyperlinking
I have several ws I use as check registers. I'd like to be able to go
to the last non-blank row in that ws when I click that register's ws
from the index page. It would always be the next available row in the
applicable ws. Is there a way from HYPERLINK to do that or maybe a
function once I get there? Macro?
here are a couple different ways:
this will select the cell. it's not a good practice to select, but just used
an illustration here.
Sub FindLastCel...Blank body on E-mails received with signature and attachment
When I get an e-mail that has an attachment and a signature, either the
message body will be blank or the body will have text but the signature will
not appear in the body. There will be a .txt file along with the attachment
which is probably the signature but when I click on it I get "access is
denied". Are there settings that will allow the signature to be displayed in
the body of the text? The sender is using Eudora 7.
Do you have a virus scanner installed which integrates itself with Outlook?
Uninstall this integration part of your virus scanner and try again; you...Publisher
Have set up a small report 10 pages in total but when printing page 9 I get
additional blank pages printing and then my page 10 how do I stop this from
Open the Design Checker, see if it tells you anything. Is the page visible in
What version Publisher?
Is the publication setup as a booklet? Publisher works in groups of 4 when
printing a booklet. With a ten page booklet setup, Publisher will print a blank
"charliegirl" <firstname.lastname@example.org> wrote in message
news:F995943A-B6A5-4B6B-...Days Old formula?
Hi im having a problem trying to figure out the forumla for days old. M
teacher wants us to come up with a formula for the age of 2 dates.
Does anyone know any formulas that will work?
Message posted from http://www.ExcelForum.com
If you need the days only, subtract
"frackskat004 >" <<email@example.com> wrote in
> Hi im having a problem trying to figure out the forumla for days old. My
> teacher wants us to come up with a formula for the age o...Show userform at spreadsheet open
How do you make a userform open when you open a spreadsheet?
Can anyone help?
sheet or file?
Private Sub Worksheet_Activate()
lookup modal and modaless forms in vb help.
Private Sub Workbook_Open()
also see this site....
"Roger on Excel" wrote:
> How do you make a userform open when you open a spreadsheet?
> Can anyone help?
&g...How to convert to absolute value?
How do I convert numbers to absolute value?
Edit - Copy.
Edit - PasteSpecial - Values - OK.
Or do you want a code solution ?
HTH. Best wishes Harald
"Betsy Marlow" <firstname.lastname@example.org> skrev i melding
> How do I convert numbers to absolute value?
On Thu, 24 Aug 2006 15:16:31 -0400, "Betsy Marlow" <email@example.com> wrote:
>How do I convert numbers to absolute value?
>...Viewing Formulas instead of formula results
I want to view all of the formulas in my worksheets
without going through each cell and typing " " around each
formula. Is there any way to do this so I can check all
of my formulas at once?
Meghan, here is one way, use Ctrl and ~, this will toggle between formulas
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
"Meghan" <firstname.lastname@example.org> wrote in message
news:00db01c351f6$4eb0...Don't plot zero values
I am currently using Excel XP. I have a scatter chart and would only like to
plot non zero values. These are not null values. Is there a chart setting I
can do to skip plotting zero values or do I need to somehow filter/sort the
data first and then plot?
Hey George -
If there are true zeros in the data, perhaps the easiest way to exclude them from
the chart is to use an autofilter on the data that hides the rows with zeros.
Alternatively, you could insert a column to hide the zeros. Say the range with zeros
is in B1:B10. Select C1:C10, and enter this formula into C1:
Hi- I need help creating a formula that sums values in a list based on
the value in an adjacent cell. Please see attached screen shot.
Hopefully it explains what I'm trying to do.
|Filename: excel help 3-10-06.gif |
|Download: http://www.excelforum.com/attachment.php?postid=4442 |
rhovey's Profile: http://www.excelf...diable command button based on field value
I have a command button which I would like to disable based on the
If A = 1 then button is disabled
If B = 2 then button is enabled
Where you put the code depends on how the form works. If this needs to be
checked for each record, use the form current event:
If A = 1 Then
Me.Button.Enabled = False
ElseIf B = 2 Then
Me.Button.Enabled = True
But, what if A is not 1 and B is not 2?
Dave Hargis, Microsoft Access MVP
> I have a command button which I would like to disable based on the
>...Transactions don't show latest download
This is a multi-part message in MIME format.
I've downloaded my transactions from my bank, it registers in =
MSMoney2004 as downloaded, but the transactions don't show in the =
account. How do I force the program to recognize and list the =
<!DO...Convert 2002 D/B to 2000 shows no details
When I attempt to use the [Tools];[Database Utility]; to
[Convert Database]; to Access 2000 format from Access XP,
the resulting database doesn't display anything in the
Detail View. All tables and queries appear to be present
in LIST View and ICON Views but when DETAIL View is
selected the entire display is blank.
Is there a "Select Details" option in Access as there is
in Windows Explorer?
"Tom" <email@example.com> schrieb im Newsbeitrag
> When I attempt to use the [Tools];[Database Utility]; to
> ...displaying negative values
how do I hide the display of negative numbers?
Regards from Brazil
> how do I hide the display of negative numbers?
That will work if cell A1 has a formula in it.
If negative numbers are just typed in, you can use conditional formatting.
Highlight the range of cells you want to format.
Go to Format > Conditional Formatting...
Enter cell value is less than 0.
Click the Format... button and select Color: and then click the white icon.
> =if(A1<0,"&qu...default mail format based on domain
After 20_ years of Eudora and Thunderbird (in that order), I'm looking
at Outlook for the first time (we're moving to an Exchange backend,
so...worth a look, for obvious reasons). In Thunderbird, if I want to
set a default HTML format for emails sent to a certain domain, I can
specify that. For any other domain(s), plain text.
Is there an easy way to do that in Outlook (I'm using 2007)?
Basically, I want emails sent to my enterprise domain (i.e., my place
of employment) to be in HTML or perhaps RTF, but mail sent to other
domains to be plain text only.
Again, I want ...Visio File Summary Dialog Box is showing wrong file name and size
I am using Visio 2003 ActiveX Control in my application using VB.NET
I am calling "visCmdFileSummaryInfoDlg" Command to open File Summary
Dialog Box. Dialog Box is open successfully but it always showing
Template file size instead of open file size in General Tab.
The information it shows is:
Type: Microsoft Visio Drawing
Size :(928 bytes)
Based on: Template - ValueStreamMap.vst
Can any one let me know about any property or way so that it shows
correct file size?
Can we assume that the new drawing has been saved to disk before you call
th...parameter values not valid #3
keep getting a window each time I try and save a new task (Outlook 2000) it
"Could not complete the operation. One or more parameter values are not
I just set up Outllook, and can't figure out why it would do this.
...How to determine the closed value?
There is a number 14 in cell A1, and there is a list of number under column B,
8, 11, 16, 18, 21
I would like to determine the value within the list, which is closest to 14,
and 16 should be returned in cell A2.
8, 12, 16, 18, 21
I would like to determine the value within the list, which is closest to 14,
and because 14 is between 12 and 16, then I prefer the larger number, and 16
should be returned in cell A2.
Does anyone have any suggestions on how to do it in Excel?
Thanks in advance for any suggestions
Hi Eric, this should do it:
=INDEX($B$1:$B$5,L...How do you do cross worksheet formulae's
I've just started writing basic addition and multiplication formulae
etc. for multiple cells. I want to know how to write formulae to d
this across worksheets (I think thats what they are called - the tab
at the bottom?) For exaple, how would I add A1 on sheet1 to A1 o
Liam Greene's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=897
View this thread: http://www.excelforum.com/showthread.php?threadid=26786
Liam, if you formula is in sheet one, =A1+Sheet2!A1, if you f...need Blank column in invoice
How can I make(or hide) contents of cell unless the cell before it isfilled
in? Hope i said that right. My invoice has a payment col and balance col
next to each other,. I want to have the formula in the balance column all
the way down, but it should be emty until a payment is filled in?
Trap for no entry in the payment column by entering a formula in the balance
Gord Dibben MS Excel MVP
On Wed, 19 Apr 2006 21:48:18 -0400, "Frank"
<stratster68@IHATESPAMworldnet.att.net> ...Set value of const member variable in Init() function?
Is there a method for setting the value of a const member variable in
an Init() function when the value is unknown in the constructor?
"Harvey" <firstname.lastname@example.org> wrote in message
> Is there a method for setting the value of a const member variable in
> an Init() function when the value is unknown in the constructor?
I don't believe so. But be careful of the difference between
const int x=1;
const char *pszString;
pszString = ...
The latter is ok as the pointer is not const - th...how do I get the if function to return a blank cell, not 0?
I am trying to create a chart from a series that contains data for each
month. The series is calculated on other worksheets and copied to the
worksheet containing the chart. I would like to have the cells for the
months that have not been updated yet (now is January, there are 0' in all
cells for Feb-Dec) to be blank (to create gaps in the chart) not 0's.
Can this be done?
Unfortunately, what you want, and what many of us have requested but doesn't
exist, is a worksheet function like BLANK() or NULL(). The best we can do is
use NA() in a chart's data source, which is...How to save the value in the CEdit control to a text file?
Im generating a random number to the CEdit control and now i want t save all of this value to a text file. I dont know to code it in the way of MFC. I hope whose know it can send me the soding cause im running out the time to do my project
You can use GetWindowText to get its contents and then use CStdioFile class to write the
text. MSDN has enough documentation on this.
Ajay Kalra [MVP - VC++]
"TLee" <email@example.com> wrote in message
| Im generating a random numbe...Sum Formula Question
I was having trouble with a specific formula. Assistance would be greatly
I have a form that contains a form header, detail, and form footer.
The detail section contains fields that are doing calculations. There is a
text box that has source info going into Hours on a table.
The data on that field has a formula:
=DSum("[Hours]","Labor Metrics","[Tech manual ID] =Forms![Labor Metrics
(Project)]![Labor Metrics (Project) subform]![Tech Manual ID]")
When the form is run, it brings up information for all the directed results.
I am trying to get the...How to slot cell values into pre-defined ranges
I would like to slot cell values starting from 500 upto 75000 in ranges
(bins) like 500-999, 1000-1499, 1500to 1999 etc. How do i do this? I have 15
Not sure what you want here. Do you want to count the number of times values
within a range occur?
"KDD" <KDD@discussions.microsoft.com> wrote in message
>I would like to slot cell values starting from 500 upto 75000 in ranges
> (bins) like 500-999, 1000-1499, 1500to 1999 etc. How do i do this? I have