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...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...VLOOKUP Function #8
What is the error in the Range lookup
ie. Entering True or False
with true the lookup column has to be sorted since it will look for the
first value where your lookup value is greater than or eqqual to the value in
for false, an exact match must be made. and an error is returned if there
is no match. sometimes the non match for cells which look alike is the
result of format issues.
"John H" wrote:
> What is the error in the Range lookup
> ie. Entering True or False
could anyone tell me which file(s) emails are stored in with outlook 2003
and outlook express
Outlook Express: *.dbx
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1
"jb7846" <email@example.com> wrote in message
> could anyone tell me which file(s) emails are stored in with outlook 2003
> and outlook express
...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.
...Problems with "find" function
I sort alot of email and use "find" alot. A few days ago
it just stopped working i.e. when I do a find it just
scans and scans and produces nothing. This just started.
Any thoughts? Thanks Bill
...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...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...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....Search Function
Does anyone know why the search function on this discussion group is not
working? I do not know who to report it to. Thks
It comes and goes. This "discussion group" is really a newsgroup with a
"web interface" pasted on the front end. You can bypass it and use a
news reader directly using the link below.
> Does anyone know why the search function on this discussion group is not
> working? I do not know who to report it to. Thks
I use Mozilla's Thunderbird as a new...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...Consistent function of Utilities logon screen when applying hotfix
When our users attempt to install a hotfix roll-up, when they are logging
into Dynamic Utilities for the first time, the user interface is very touchy.
What I mean is that they must click the username field and then type. Then,
they must use the mouse again to click the password field and type. Then,
they must click the OK button. If they try to use backspace, enter key, tab
key, etc., extra characters are inserted. The only way that they can "edit"
their username and password information during logon is to use the mouse to
highlight and the type over the information.
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 ...IF Function #2
Here is a nice easy one!
I have a value in a spreadsheet that I need to check. If the valu
<-0.005% or >0.005%, then I need to notify the user that an adjustmen
I tried this
=IF(C27<-0.0049999,"adj required",(IF(C27>0.0049999,"adj required","n
but alas it doesn't work. Can anyone help?
sgrech's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1450
View this thread: http://www.excelforum.com...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 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 ...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...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 ...Outlook Express 6 Address Book
I rememember the last time I used Outlook Express, when u
opened the Address Book, and viewed my list of Contacts,
there was an option to change the view so that you could
say show the nickname first, then the name, then phone,
and nothing else .... am I missing it? What do I need to
do to change the view?
Thanks for the help.
Please post in an Outlook Express Newsgroup.
"TC" <firstname.lastname@example.org> wrote in message
> I rememember the last time I used Outlook Express, when u
> opened the Address Book, a...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...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...