|
|
excel to outlook by
Aaron
Good afternoon,
Is it unheard of to use a spreadsheet to, in a way, merge to an email.
meaning, if I have a generic bodied letter, and a spreadsheet the...
|
|
2 |
82 |
|
|
Custom Formatting by
Aaron
Hi,
I have a cell that I want to have a number and a letter in, ie 0.02 g.
I need to be able to set this format based on another cells current
formatting...
|
December 9th, 2008 06:10 AM
by Aaron
|
2 |
77 |
|
|
Increase & Decrease Decimal Place by
Aaron
Hi,
I have a macro tied to a button called UP
Sub DPshiftup()
'
' DPshiftup Macro
ActiveSheet.Unprotect
With Range("Q16")
If .NumberFormat =...
|
December 9th, 2008 01:27 AM
by Aaron
|
6 |
69 |
|
|
Number Format by
Aaron
Hi,
Im using
..NumberFormat & " \g" sucessfully, but I cant use .NumberFormat & "
\kg" as excel says it cant set the number format.
Why should it care...
|
|
4 |
81 |
|
|
Number Format by
Aaron
I have this macro code:
Range("u22:u26").NumberFormat = _
Range("ad22").NumberFormat '(number format in ad22 is "0.00")
Dim KeyCell As Range, AnswerCell As...
|
December 18th, 2008 10:58 PM
by Aaron
|
4 |
76 |
|
|
|
|
6 |
88 |
|
|
|
August 22nd, 2006 04:13 PM
by Toppers
|
1 |
55 |
|
|
number format by
Aaron
Hello,
I have some data that needs to be parsed...like this:
Z:\02\ALPHA\0025.txt
I'm trying to text to columns fixed width in order to get the 0025...
|
|
1 |
79 |
|
|
|
|
2 |
167 |
|
|
|
July 21st, 2006 07:34 PM
by bj
|
4 |
59 |
|
|
Link is missing by
Aaron Dyck
I have recently inherited a spreadsheet upon taking a new job, and one of the
links in the sheet is broken. I do not need the link, and I have attempted to...
|
|
1 |
49 |
|
|
Counting Multiple Text Cells by
Aaron G
I am trying to determine the formula to count - only if the criteria in two
(or more) cells is true.
Example Data Set
Service Equipment
Data ...
|
|
4 |
94 |
|
|
IF formula help - incorporate greater than & smaller than by
Aaron Hodson \(Coversure\)
I am trying to use the below formula in cell C7:
=IF(P7=0,1,IF(P7=01,2,IF(P7=12,3,IF(P7=23,4,IF(P7=34,5,IF(P7=4,5,0))))))
The idea is that if P7 equals...
( 1 2)
|
February 12th, 2008 05:06 PM
by PCLIVE
|
10 |
136 |
|
|
conditional formatting - repeat formula by
Aaron Hodson \(Coversure\)
Hello,
I am trying to perform a basic (!!) task which involves a table where the
lowest figure requires to be highlighted.
I used the formula in conditional...
|
|
7 |
114 |
|
|
find & select by
Aaron Hodson \(Coversure\)
I have a number of PCs which are running on XP office software.
After using a machine running Office 2007, I was impressed with the find and
select facility...
|
|
2 |
57 |
|
|
|
|
3 |
63 |
|
|
IF formula with 3 possible outcomes by
Aaron Hodson \(Coversure\)
Hello everyone,
I am trying to get the following formula to work, without success.
I would like C3 to have 3 possible outcomes, 1,2 or 3. This data will be...
|
|
8 |
118 |
|
|
INDEX FORMULAS & MULTIPLE TABLES by
Aaron Hodson \(Coversure\)
Hello everyone,
I am using the below formula to capture data from a table in my spreadsheet:
=INDEX(F3:H22,MATCH(B9,E3:E22,0),MATCH(B3,F2:H2,0))
Within the...
|
|
9 |
89 |
|
|
|
November 1st, 2007 12:12 PM
by Gav123
|
3 |
63 |
|
|
|
|
5 |
190 |