Conditional formatting
Fri, 05 Mar 2010 22:41:26 -0800
I am using Excel 2007.
I am trying to format time values that can range from seconds to
years. If the time is below some threshold, say 1 day, I want to use
the hh:mm:ss format. If it's larger that 1 day, I want to use the 0.00
format. After a little study, I selected this conditional format
string:
[<1 ...
|
Extracting Values from text embedded in cell
Fri, 5 Mar 2010 15:35:54 -0800 (PST)
Thanks very much in advance for any solutions that can be offered.
I have the following in cell A1: 123456-text 3" x 6 7/8" etc etc
I have the following in cell A2: 654321-test 104 1/2" x 80 3/4" etc
etc etc blah blah blah
I would like to extract from A1 the value 3 and 6.875 into another
location (ie. 3 in ...
|
Extracting Values from Text
Fri, 5 Mar 2010 15:21:53 -0800 (PST)
Thanks very much in advance for any solutions that can be offered.
What formula would I use to provide the following result:
A
B C
1 123456-text 3" x 6 7/8" etc etc 3 6.875
2 654321-test 104 1/2" x 80 3/4" etc etc 104.5 80.75
The length is always s ...
|
Need Help with a Formula
Fri, 05 Mar 2010 15:04:49 -0800
I need some help: In this example I have a column of 5 cells B1:B5. I
also have another cell C1. I would like to have cell C1 to display the
most recent entry in the B Column.
Start
B1=Null C1=Null
B2=Null
B3=Null
B4=Null
B5=Null
First Entry
B1=4 C1=4
B2=Null
B3=Null
B4 ...
|
Printing to Day-Timer pages from Excel 2003
Fri, 5 Mar 2010 14:24:32 -0800
I have old printouts that indicate that in the past I printed from an older
version of Excel to 3.75"x6.75" pages, but I don't see any way to do that
using Excel 2003. How do I do that from Excel 2003? ...
|
validation for decimals
Fri, 05 Mar 2010 16:23:31 -0500
Hi there.
I need to set a series of cells so that the user cannot enter anything
other than 2 decimal currency values. Here's my code for this:
.Range("K" & sI & ":K" & sI).Validation.Add Type:=xlValidateDecimal,
AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:="0.00",
Formula2:="999999999.99"
...
|
Excel 2007 Ribbon - Remove unwanted custom toolbars
Fri, 5 Mar 2010 11:35:01 -0800
We had a series of engineering worksheets created in earlier versions of
Excel that utilized custom toolbars created solely for the worksheets. they
would be attached to the files which is how they were distributed to guys out
in the field.
Now that we are in the Office 2007 realm, our custom toolbars have be ...
|
|
|
Title Capitalization
Fri, 5 Mar 2010 10:15:25 -0500
Is there anyway to for a column to use Title Capitalization?
--
...
|
Printing Multiple Sheets
Fri, 5 Mar 2010 04:59:01 -0800
I know that I've done this in the past without any problems, but I'm using a
new (to me) computer running Excel 2003, and am having trouble printing
multiple sheets at the same time. I'm trying to select 2-3 tabs and printing
them all as a group. The advantage is that page numbers in the footer
reflect t ...
|
File won't Calculate
Fri, 5 Mar 2010 04:44:01 -0800
I have a 35MB file that locks up when calculating. It's a process that has
been use for several years; each year I do a "save as" to create the current
year's evrsion. By year end, it can grow to ~65MB. I never had a calc problem
before and it has worked fine all this year up to now.
Any ideas?
Thank you ...
|