|
|
Custom Format with different Criteria by
Santhosh Mani
I need to format a complete column of cells as below. I tried format Cell
Number Custom but accepts only two criteria, not all eight criteria listed...
|
|
2 |
179 |
|
|
custom formating a cell by
VDU
Hello, I have a problem in creating a custom format and I'm running out of
time, could you please help me.
I have a cell containing a series of concatenated...
|
November 22nd, 2006 09:00 AM
by VDU
|
2 |
70 |
|
|
Custom Formating Cells by
JohnWFUBMC
I want to format a cell so that when I type a number into that cell it will
take the absolute value of that number and then multiple it by 1000. Is
there...
|
|
2 |
102 |
|
|
|
|
2 |
139 |
|
|
Custom formating of cells by
Dale
I have a number in a cell that is in whole numbers that I needs to be
reported in $,000. In the Format cells menu on the nubers tab there are
several...
|
|
2 |
61 |
|
|
|
February 8th, 2006 12:46 AM
by Brian
|
2 |
118 |
|
|
Custom Formatting by
Tarfun
What is the custom format to display numbers to the nearest 100 or nearest
10, i.e., 721 be displyed as 700 or 720. I know that formattig a number that
way...
|
|
7 |
92 |
|
|
Custom formatting by
Yvonne
I have a very large spreadsheet in which I need to change all dates that
appear this way: 1994 - 1995, to this: (1994 - 1995).
Is there any way I can...
|
April 3rd, 2008 04:40 PM
by Ivyleaf
|
4 |
129 |
|
|
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 |
|
|
Custom Formatting by
Nikki
I want to format a row to change background color if a cell in the row says
PD10/ 05. But it won't always say 05- how can I make a generic for that in
an...
|
|
2 |
84 |
|
|
custom formatting cells by
lisa & corinne
we are trying to remember how to show 7 (type only the
seven in the cell) as .0007, by formatting the cell. we
have tried several different custom formats,...
|
|
2 |
409 |
|
|
Custom formatting not functioning in Excel by
Seenath
I have an Excel sheet in which date related formulae were working properly.
But now the Format-Cells-Custom- ddd, d/mmm/yyyy is not accepted by Excel.
Date...
|
|
1 |
108 |
|
|
|
|
1 |
76 |
|
|
custom formatting?? by
PattiTechWriter
Do you know if you can force a specific formatting for a column? What I want
to do is, I have a column with a MAC Address that looks like this:
005004a1b4a9...
|
|
2 |
218 |
|
|
Custom Formula in Pivot Table Row by
Cam
Hello all,
I use Pivot Tables (Excel 2003) to create Profit & Loss statements.
I would like to insert a custom formula to calculate 1) Gross Profit
and 2)...
|
|
1 |
102 |
|
|
Custom function by
Christina L.
I have written a custom Excel function in VBA which retrieves data from a
remote server. This function can take up to several seconds to run, depending
on a...
|
|
1 |
88 |
|
|
Custom Function by
Spencer Hutton
I have written a simple VBA function:
Function SpenceTAX(Cost, Rate)
SpenceTAX = Cost + (Cost * Rate)
End Function
it adds tax to an items cost. how do i...
|
|
2 |
114 |
|
|
Custom Function & Personal.XLS by
Excel 2000 SR1, Win2kPro
Using a custom function works fine if the module is in my
current workbook, but when I move the function to the
module in my...
|
|
1 |
329 |
|
|
Custom Function basic by
Joe_Germany
Hello all..
I am trying to make a custom function.. I am using german Excel..
My qn is - Can we use the standard functions inside vb..
For eg, ...
( 1 2)
|
August 31st, 2006 07:05 PM
by Pete_UK
|
12 |
131 |
|
|
|
|
4 |
297 |