Appointment times won't post correctly
On the calendar, appointments, meetings, etc. made or received show up on
the date and time received or sent; regardless of the actual date or time of
the appointment. Is there a setting that will correct this? I've exhausted
myself trying to find a fix.
There is a seperate calendar time zone setting that has to be set in
addition to your system clock. Pain in the ass. Go to Options and then
select Calendar. You should see the Time Zone button there. Set it
accordingly, but be aware that everything in your calendar up to that point
"Keith Wilso...office 2003 w/ windows 7 requires reacceptance ot T&C's each time
office 2003 w/ windows 7 requires reacceptance of T&C's each time i open work
or excell or any office program. How do I get rid of this?
Boot into Safe mode in Windows 7,open any Office app and then accept the terms
Please Reply to Newsgroup for the benefit of others
Requests for assistance by email can not and will not be acknowledged.
"mouser830" <firstname.lastname@example.org> wrote in message
> office 2003 w/ windows 7 requires reacceptance of T&C's each time i op...Combining cells to create a formula
I have two cells that I want to combine to have a working formula
B1 = sum
B2 = d3
b3 = =b1&"("&b2&")"
D3 = 10
The result in b3 is : sum(d3)
How do I get this to result in the actual value in D3.
I know I can simply write =D3, but the actual reason for combining the two cells is more complicated than explained here.
I think you are perhaps looking for the Indirect function
would return the value contained in D3
As you copy down, the formula would alter to 4, 5 etc. represent D4, D5 etc.
R...in excel how can we put formula to convert numericalfigureto word
for example :
in excel i have mention 25000.00 in numerical amount , i want to know how
can i convert in next colum , about word ?/;
How can i put formula to make the numerical in to words like 25000 in
numerical to twenty five thousands in word.
There is no direct functions to convert this. For a VBA solution check out
the below links
Jacob (MVP - Excel)
> for example :
> in excel i hav...Formula Question #18
I have built a workbook in which I have inserted a formula to tell me whether
the contents of a supply bin needs replenishment or not. The formula I used
is: =IF(E3>F3,"REPLENISH!","No Action"). Each morning, I run a report to see
what parts have been used, which becomes a new sheet in the workbook.
Now, I want to add a formula that, whenever it sees "REPLENISH!," it will
back through the workbook to count whether that same part needed
replenishment on consecutive previous days. If it has, then the latest
worksheet will report the number of days that ...Move/Copy A Row Based on Formulas to a New Worksheet
I want to move several rows of sub-totals (averages within sub-groups) to a
summary worksheet, but I get the Ref error. How can I copy sub-group averages
to another worksheet?
high light and copy.
select where you want it.
this will turn you formulas into hard numbers.
you are getting the #Ref error because on the other sheet
where you pasted the formulas, the formula no longer had
the same references that they had on the other sheet.
=sum(a1:a10) in cell a11
you copy and paste on another sheet at cell a1.
excell tries to compensat...Erase data, preserve formula's
I have a an excel file with 12 worksheets for the financial year and an
additional worksheet for yearly totals.
I need to get a blank copy of this and was wondering if anyone knew a
way to delete all the user inputted data while keeping the formatting
and formula's intact.
Any help is much appreciated.
urbanfox's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=22826
View this thread: http://www.excelforum.com/showthread.php?threadid=519004
Hit F5 and select Special a...How do I set up a formula in excel that is the tenth root of 7 ve.
How do I set up a formula in excel that is the tenth root of 7 versus the
square root of 7?
try the formula =7^(1/10).
"kestig1" <email@example.com> wrote in message
> How do I set up a formula in excel that is the tenth root of 7 versus the
> square root of 7?
...Need help with formula 01-13-10
I am trying to adapt a formula in I2 from another spreadsheet that works
well, but won't in mine. I've traced the error, but I would need help to
understand the help it gives! My formula is this: =IF(J2="0-Jan-00","To be
advised",WORKDAY(J2,1,NWD)). I have a worksheet in the same workbook with a
list of non-workdays, and defined the column of dates with the name "NWD".
What I expect the formula to do is this: If J2 is Feb. 4, it would give Feb.
5 in cell I2 because Feb. 5 is NOT a non-workday in NWD. But if J2 is Feb.
5, and Feb. 6 and...Please help..with a formula. I don't know code.
I have a long list of numbers - values in a file X, and I want to fin
and replace those values in a even larger list in a file Z an
highlight those values in Z
Message posted from http://www.ExcelForum.com
not really sure what you're trying to achieve. What do you
want to replace, etc. You may give an example (plain text -
no attachment please)
>I have a long list of numbers - values in a file X, and I
want to find
>and replace those values in a even larger list in a file
>highlight those values in Z.
>Message...Keyboard shortcut for current date and time
Ctrl+ ; inserts current date and Ctrl+Shift+; inserts current ti me
Ctrl+Shift+; inserts the current time with the date serial as 0 and
not the current date's date serial.
Presently I am adding the two (ie current date and time) to get the
current date and time. Is there a keyboard shortcut that does this?
Thanks in advance.
CTRL+; then SPACE then CTRL+SHIFT+;
Portland, Oregon USA
wrote in message
Ctrl+ ; inserts current dat...Set default time zone for all users
Is there a way to make the time zone default to a certain value so that I don't have to go into every user and change it to the correct zone?
No. Each user must change their own timezone settings. I have no idea why
Microsoft do not pick up your computers timezone. Hopefully this will be
changed in a version 2.0 release
"Jack Black" <firstname.lastname@example.org> wrote in message
> Is there a way to make the time zone default to a certain value so that I
don't have to go into every user and change i...formula: counting presence
I have to count presence of employees from sheets between START and END,
which is stored in G9 cell. I think it should be something like:
=SUM(IF(START:END!G9="present"; 1; 0)), but this one returns #REF and I
don't don't why.
Try these from a post of mine today.
Put the sumif on each sheet with an indirect reference to d12 of the master.
=sum(sheet1:sheet21!a2) where a2 in your sumif formula.
One way to put=SUMIF(B:B,Sheet1!D12) on each sheet is to select all>type the
formula in the cell desired>after the error msg>delete from the ...Help on Macro or Formula
i hope someone can help me. i need to create a formula that sits in a cell
and looks for data. ( obvioiusly ). however, the formula needs to be in place
even though the file from ehere the data comes from might not be there yet. (
i have to create a book that when a new file is created, the links are
already in place ). i think it could work with an IF type formula for ( if
B2="",""). here is my information.
A2 = Job no.
B2 = Client Name
D2 = Actual Spend on project
Register!D2 = Job Description
Register!H2 = Quoted Amount
my path is S:\Clients\...Formula for date field
1.I have simple dates in one column (say column A) .
2.In the next column(Column B) I would like the date five months after
Column A to be displayed.Eg if Column A has an entry of 9th June
2007,Column B should display 8th November,2007.
3.A simple formula does not do the job as this does not take into
account the different number of days in different months!
Your post is a bit ambiguous since you don't really say how the
different number of days in months should be handled.
In articl...New Named Range Created Each Time Data Imported into Excel via Macro
I have noticed that each time I import data into an Excel spreadsheet
via a macro, a new named range (for the same range) is created. This
does not pose a problem, but after a while, I'll have a huge number of
named ranges that will never be used. Why does Excel name the range
and how can I stop this? I noticed in the recorded macro, there was a
line .Name = "drd_5". I commented this out to see what would happen,
but it just renamed the range "ExternalData_5". The next one was
You could refresh with differen...Copy/Paste formulas
How do I keep certain cells (those I want to point to a specific 'constant')
from incrementing while the remaing cells in my formulas increment as
expected. Example: ((E65)*(COUNTIF(I7:I7,"V"))) where the cell "E65" contains
a set value that I want to be placed in the result as I step down the
incremental (I) rows when the character "V" is found in the particular (I)
row. When I do my copy and paste, the (E) row increments as the (I) rows
> How do I keep certain cells (those I want to point to a specific...Getting Cell Value from the Concatenate formula
I built a concatenate formula that returns the following result: =Jul!
I am looking for the cell contents of Sheet: July Column D Row 27.
I tried to use offset, but I am stumped. Can I add something to the
front of the concatenate to not only build the reference to the cell,
but also return the value instead of the =Jul!$D27 ?
Don't include the equal sign in your formula. And match the name correctly (Jul
Depending on the name of the worksheet, you may need to have a string that looks
=indirec...stop automatically changing formula!
i have a countif function
when i copy this and paste it to the next cell, the formula automatically
change to COUNTIF(Locking!J16:J40,"f")
How do I stop it from changing column I to J?!?!?!
MS Excel MVP
"caryn" <email@example.com> wrote in message
> i have a countif function
> when i copy this and paste it to the nex...Formula for competition timesheet
Here is the situation. I have a number of members in a clay target
club who shoot a competition over a number of ranges. Ranges 1 to 8.
They shoot a competition over 4 days. They start shooting at a
specific time each day. Start time in cell A1. The duration of the
time they spend on each range is specified in B1. These times may
vary each day.
I have set up a table in the worksheet that shows the squad numbers in
column A, the ranges they shoot each day and the time they start to
shoot on each range.
This table only shows the squad numbers up to the number of members
shooting, which is ...time #11
I have set up a spreadsheet with time based on what our company truck
drivers work. We work under a DOT rule of 70 hours / 8 days. That
means that the driver can not work more than 70 hours in an 8 day
The sheets I have (one for each month) goes back 7 days plus the
current day and calculated how many hours a day the driver works and
subtracts it from 70, leaving how many hours they can work the next
day. If the calculation gets to 0 or above, the cell changes color to
alert me that the driver's 70 hours are up and he/she has to have 34
hours off before he/she can be on duty ...HOW DO I COPY FORMULA WITHOUT CHANGING CELL REFERENCE
My cell c1 contains the formula b1-a1.when i copy this formula to cells d1
and e1 the cells d1 and e1 have the following formula :
but i want the following
d1 should be b2-a2 and
e2 should be b3-a3
how do i do this?
In C1 enter & copy across:
> My cell c1 contains the formula b1-a1.when i copy this formula to cells d1
> and e1 the cells d1 and e1 have the following formula :
> but i want the following
> d1 should be b2-...why I see times new roman?
I have several html email messages composed in outlook express 6,
I'm sure I highlited all text and set it to Arial 10.
Then I drag the file to desktop, move it to vista windows mail draggin
into inbox or other folder. The result is some parts of text shows arial 10
some others Times new roman 10 or 12 what is annoying, because I use
all arial 10, so I have to manually forward the email, highligh it again and
set arial 10
and then, yes, I can see it properly.
I checked the compose default font and everything is fine.
Why is that? Is there any work around
, helo...Formulas in Excel using [R-1] not A10 references
I converted a Word document into Excel 2003 and when creating formulas,they
are formatted as the cell the formula is in plus or minus a number of rows or
columns. An example: =SUM (R[-4]C:R[-1]C). I would like to see these
formulas in the regular format referencing Row and Column number i.e. =Sum
Tools >Options, the General tab, uncheck R1C1 reference style
> I converted a Word document into Excel 2003 and when creating formulas,they
> are formatted as the cell the formula is in plus or minus a number of rows or
> columns. An example...Times Subtraction Whith Access
I need to know how to subtract between two times variants and to get a
time result (With Access).
Access really isn't intended to do things like that, but
?Format(#18:05:50# - #08:00:10#, "hh:nn:ss")
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
<firstname.lastname@example.org> wrote in message
> I need to know how to subtract between two times variants and to get a
> time res...