General
in [Excel]
|
Automatic display positive or negative Dear All, pls help me. when I type $ 52.00 on C1, I want C1 display positive $52 or negative ($ 52) , if B1 is positive or negative, I want the entire column C. Exemple : C1 : I type $52, it display for me $52 , because B1 is positive C2 : I type $52, it display for me ($52) , because B2 is negative B ... 8 May 2010 06:51
Excel 2007 Selection Tool Broken? I am using Excel 2003 at work and Excel 2007 at home. I have a file that uses hundreds of text boxes and images. At work, using Excel 2003 I can use the “Selection” tool to quickly “lasso” several text boxes or images to work on them, move them, delete them etc. At home it is nearly impossible to use the sele... 8 May 2010 00:27
Missing question Dears, How can i find my question that i have sent to you but unfortunately can't remember the question's subject? and also i haven't received replies in my mailbox Khaled.shaheen(a)hotmail.com ... 7 May 2010 23:22
Command Button I am unable to locate the section I need to add a commandbutton to excel worksheet. Where can I find this at? Thanks, Les ... 8 May 2010 00:27
budget setup I have set up a budget for an event that I'm planning. Is there a formula that I can use to determine the ticket price that I need to charge? ... 7 May 2010 22:16
Need suggestions on layout to report/pivot Does anyone have any thoughts on how to arrange this in Excel 2003: I have a group of invoice numbers. I have columns of inforamtion relating to the invoice: inv #, total amount, inv date, etc. That is currently set up with the numbers in the first column and the rest of the information in the columns next to ... 11 May 2010 11:11
Check if variable is range This is probably very simple but I just don't see it. How can I see if a (variant) variable is a range or something else (e.g. a string) Sub WhatIsIt() Dim vrString As Variant Dim vrRange1 As Variant Dim vrRange2 As Variant vrString = "This is a string" Set vrRange1 = Range(Cells(1, 1), Cells(1, 2)... 10 May 2010 09:53
Hide error messages? I have error messages in a spreadsheet that show because I have not entered data in another cell. How do I keep this from showing until I enter a value in another cell that is part of the formula? ... 7 May 2010 15:38
Print is not WYSIWYG I have an Excel sheet where I have inserted shapes to indicate grouping subtotals. These shapes are not printing where they are placed on the worksheet. Why is this not "what-you-see-is-what-you-get? ... 7 May 2010 15:38 |