Default column formats
Hello, How can I change the default column formats for all opened and new
books. EG: Format of column's 1, and 3 are general, and column's 2,5,6 are
can't to that.
but sounds like you are using the format a lot.
set a blank wb to this format. when you need a new wb with
this format, call this one. when you save it, do file save
as and give it a different name. this way you will always
have a wb set to this format.
>Hello, How can I change the default column formats for
all opened and new
>books. EG: Fo...Help with SQL statement- Supplier List cost into cost field in Ite
Hi, I've a customer who has a number of items in their HQ database at zero
cost. However, for these items there is a cost price detailed on the Supplier
tab. Items carried only have one supplier. They'd like to get this cost
copied into the cost price field on the General tab and because we're talking
about a few thousand items, this isn't something they want to do by hand! I'm
familiar to a point with SQL but because we're talking two seperate tables, I
really wouldn't be sure where to start with the syntax. Could someone please
point me in the right directi...Problem with cell formatting and underlining
I'm using Excel 2007, SP1. I'm having a problem with cell formatting.
Here's the situation:
Normally, if data are entered into a cell, they will appear past the edge of
the cell as long as there's nothing in that cell. And that's what I want.
However, if I choose to mark the contents of the cell as Underlined,
everything goes wrong. The cell will clip all text that falls outside the
border of the cell.
Does anyone have any idea how to either fix this or get around it? I'd
hoped that SP1 would have solved the problem, but no.
Work...Auto Formatting Cells and Dates
I noticed that if you type in something like 3/16 excel will assume you meant
March 16th and change the cell to a date. I know you can change the format
to text before you type the date in. Can you turn it off completely? Are
there any options you can change concerning this feature (like the date
format it changes to). Can you create your own autoformats concerning
numbers other than dates?
preformat the cell as Text
start your data entry with an apostrophe: '3/16
> I noticed that if you type in something like 3/16 excel will assume you meant
> Ma...manually selected Excel cell formatting
I've installed Excel 2007 recently. I notice when I manually select
non-contiguous cells using the ctrl key that the selected cells are not
highlighted like they were in Excel 97. At first I thought I was losing the
selection altogether but I noticed that the current cell had a thin outline
instead of the heavier normal outline. It was then I saw that the selected
cells were actually very faintly shaded. I checked that the cells were really
selected by migrating through them with the Enter or Tab key. Is there any
way to make the selected calls more visible? Or is something w...User Defined fields should be accessible from shipping address
The current relationship does not allow for the customer to use the user
defined fields from the ship to address. The reason for GP not pulling the
information for the shipping address in the Customer Address Master File
(RM00102) is because it is already pulling the information in the Sales
Transaction Work tables (SOP10100). Unlike the billing information, the
shipping address can already be seen in the SOP10100 table and this is why
the table relationship between the RM00102 and SOP10100 tables is based on
the Bill to Address. There should be an additional relationship so you can
p...Format in if formula
I want to use the "if" function and change the format
(color) of the cell if the outcome is true or false.
...V-lookup and format
I am making a dashboard for work and am using lots of v-lookups t
access a spreadsheet with lots of departmental information. I have th
v-lookups for the data all figured out, my question is this: Is there a
easy way to bring the format with the data. for instance some of th
numbers are just numbers, others are percentages, thus they come to th
new cell as .23 instead of 23%. Below is an example of the v-lookup i a
=VLOOKUP($B22,'[People Hub.xls]people hub'!$E$9:$R$5000,'[Peopl
I don't want to preset the cells format in the da...Date Format #2
Frequently i am downloading some datas from our ERP,in which the date'
are downloaded as in this style.
i am not sure this in what format.But when i use the formulae
=days360(a1,b1,true) to find the difference between 2 dates,excel i
giving error msg as #VALUE!
pls help me to sort out this issue.
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
check that the cell is not in text format,
try 28/11/03 to test if there is any change....How to appear custom fields in My Task new from?
Hi, I have been created custom filed for Task , and I want to capture them
in a My Task New Form? but I dont know What i need to do?
Let me make sure I understand your question. Correct me if I am wrong:
1. You created a new custom enterprise Task field in PWA.
2. You want the field to appear on the New Task page when the user wants to
create a new task.
If #1 and #2 assumptions are correct, then you cannot add the new enterprise
Task field to the My Task page in PWA. The best you can do is to add the
new Task field to the My Tasks page by editing the My Assig...Setting Conditional Formatting in 2007 saved as 97-2003
I am working in XL 2007, but my workbooks save as the lower version.
I have two columns of cells that I would like to apply a Conditional
Format to. I figured out the Rules Manager. But I'm not sure about
applying my conditions.
I have three possible values in column A; depending on the value, I
want to set the font color in cols A and B. Would it be better to set
three separate conditions across the cells? Or use some type of IF
formula in one condition?
Use three separate conditions
Bernard V Liengme
Microsoft Excel MVP
remove cap...How to format a date to a different format
I need help in converting a date "20050205" where the first 4 numbers are the
year, the 2nd two numbers are the month, and the last two would represent the
day of the month. I have tried several things to format these and looked in
Help but I am not asking the right question. I want to be able to have the
data read 02/05/2005 or something close such as 2/5/05. The date format it
is currently would be fine if that was the only report, but I have several
other downloads that I work with and those dates are in the format I am
requesting. Also the original format is hard to re...Reprint AP check format on plain paper
Provide the ability to print a "copy" of a previously printed check w/
stub (with "void" in the signature section)
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
I have a subform based on a query. The query includes a text field for
"details" and a memo field for "Notes" in which contains additional
information which is beyond the capacity of the details field. I want
to apply conditional formatting (a change of colour) to the details
field on the subform to indicate when there is additional information
in the notes field.
I have based the conditional formatting on an expression which tests
whether the Notes field contains a null value. The notes field in
placed on the subform, as I understand that it needs to be there in
order to ...Pick up Formatting/Apply formatting
My Publisher 2000 had a wonderful feature that I used all the time. I could right click on a text frame and "Pick up formatting" then I could click on another text frame and "Apply formatting
I purchased Publisher 2002/XP, and I can't find this wonderful feature anywhere. I sure can't easily right click to get it, but could it hidden somewhere and I just can't find it?
A small child turns to Ed, and exclaims: "Look! Look! A post from Judy
> My Publisher 2000 had a wonderful feature that I used all the tim...Not all required fields have been entered
I am getting this error everytime I am trying to enter a new sales order or
purchase order in a new data base. Is there any way I can find which fields
are not being populated? I have gone over the installation at least 4 times
and I can't find anything missing. The funny thing is that the sample
database has the same error.
Is there a trace facility in GP?
Gino S. GPK Computers
Yes, there is a trace facility in GP. The name of the file is called
In install folder, in Dex.ini file modify the following from FALSE to TRUE:
I have excel 2007 (sorry for the previous post)
I have a table like this
Start Date Duration Staff Staff 2
JOB 1 5/1/2009 29 Bob Dan
JOB 2 5/1/2009 60 Jeff Denise
JOB 3 5/15/2009 61 Ben Dan
JOB 4 5/15/2009 61 Jeff Paul
I would like to be able to have different colors for each person.
Only want each job listed once on the left.
Are you trying to create a gantt chart or do you just want to color each row
a different color.
Check out the topic Gantt Charts at Jon's site:
If you only want to color ...double line format button only formats single line when added to .
When adding a double line format button to my Toolbar using the Customize,
Categories Box, Command Box and then dragging the double line format button
to my Toolbar, I only get a single line format when using this button.
It's a bug. There's a workaround in the following thread.
> When adding a double line format button to my Toolbar using the Customize,
> Categories Box, Command Box and then dragging the double line format button
> to my Toolbar, I only get a single line format wh...Date format problem #2
I have several workbooks with date-formatted cells that work properly. I
just created a new one, however, that will not display properly. I have
tried several "date" settings and also the "custom, d-mmm-yy" setting, yet
information placed in the cells come up as a date in "Jan 1900" or as
"###########" with the message that negative dates aren't allowed. I have
tried to use "format painter" from the sheets that work properly but to no
avail. What am I missing?
Thanks in advance.
If the value in the cell is negative, then ...Auto update a date field when a checkbox is ticked
Does anyone know how I can automatically populate a data/time field when a check box is ticked? This needs to be at record level. thanks
Submitted via EggHeadCafe - Software Developer Portal of Choice
Get Identity Values of Multi-row insert by using OUTPUT Clause
If you mean when the check box receives a check (rather than when it is
cleared), in the check box After Update event:
If Me.CheckBoxName = True Then
Me.SomeField = Now()
If you want th...VBA Conditional Formatting
I've been searching the groups and websites trying to find but not
getting the results I'm looking for. Thus, the post.
What I am trying to do is to have various conditional formatting
scenarios but will need to use VBA because its greater than three. The
only thing is, I'm not sure how to test a value in a specific column,
apply the formatting for the row or the specific cell value.
This is the scenario:
Criteria 1: Column B has the formula:
=IF(AND(D8=D7,E8=E7,F8=F7,C8=C7),"","IL") - If the cell value is "IL"
then it w...How to prevent user from updating fields in the task
Looking for a way to lock (prevent user from updating)
certain fields in the task after it has been assigned to
...Copying a format that has been conditionally formated
How do I cut and paste a formula picking up it's own values if the cell has
been conditionally formatted.
In example, c3 is to highligh in red/bold if it's value is lower than c29
(the value of the same info from year prior). It worked for that cell but I
want to copy the formula for the rest of the 500+ cells so that d3 also read
from d29, etc.
What, exactly, is the condition you set? I'm guessing it's something like
'formula is' =($C$3<$C$29). If you use relative cell references, =(C3<C29),
rather than the absolute references, then you should ...In Excel, how can i see all tabs in format cell
When I try to formal some cells and I go to Format -- cell I get all the
options including alignment, but in other cells I only get the font tab. I
just want to change the alignment on 1 cell from bottom to top.
If you select the cell, and choose Format > Cells, you should see all
If you double-click on a cell, or click in the formula bar, so you're
editing the cell, you'll only see the Font tab if you choose Format > Cells.
> When I try to formal some cells and I go to Format -- cell I get all the
> options including alignment, but in other cel...How do I put a formula in a dialogue box; to be placed on a chart
I want to create a separate little box on my chart that will contain a
formula that references cells not necessarily contained in the data ranges.
Microsoft Excel 2002 on a WinXP SP-2 operating system. It would look like a
text box in the upper right corner of the chart, but would contain a formula,
You mean you want to link the textbox to a cell? Select the textbox, then
type = in the formula bar and click on the cell.
You cannot build a full-fledged formula in a textbox like this; build the
formula in a worksheet cell, and link the textbox to this cell.