Why is Actual Work updated when entering time into Work Field?
We're using MS Project 2007 and seeing that sometimes when time is entered
into the Work field for a task, that task's Actual Work is updated to the
same value entered in the Work field. This happens to multiple resources,
but only on some of their tasks and not on others. For example, for the
weeks of 1/24 and 1/31, whatever hours I schedule (enter in the "work" cell
in the Resource Usage View) for a given task also appears in the "actual"
The tasks are setup up differently. Some are Fixed Work, some are Fixed
Duration. I believe all have the e...Excel 2003 spreadsheet. I enter the any number and it is entered.
If I enter a number into a cell it is put in like a decimal. For example, if
I enter 10 it is put in as .1 500 is entered as a 5
Goto Tools>Options and on the Edit tab you should see The Fixed Decimal
Places box checked. Uncheck it.
"maryu" <firstname.lastname@example.org> wrote in message
> If I enter a number into a cell it is put in like a decimal. For example,
> I enter 10 it is put in as .1 500 is entered as a 5
> Thank you
...Filter records by date in subform by date entered in mainform.
Hello, I've spent 3 days trying to understand what I'm doing
wrong.....Here is the summary of my problem.
I have a form named 'frm_EfficiencyStats' and a subform within the
form named 'qry_Total hours subform' (the subform is based on a
query). The form contains a text box (for date) which is bound to a
I would like to be able to enter a date in the text box on my form,
and display the records in the subform based on the date I entered in
the text box. The subform will only pull records from my table based
on the date.
Here are th...how to enter simple list and sum
using excel 2002 with an xp sp2 system
how would I enter a simple list of positive and negative numbers and then create a
cell with the sum of these values?
if the list would look like this
the output would look something like
In B1 enter =A1
In B2 enter =B1+A2
Copy down to B5
Gord Dibben MS Excel MVP
On Wed, 16 May 2007 06:34:13 +0300, "John" <email@example.com> wrote:
>using excel 2002 with an xp sp2 system
>how would I enter a simple list of positive and negative...Resource Units for Tasks entered in PWA differs than tasks entered in Project 2007
I have an ePM user asking why if he enters a project task in PWA does
it not check the resource max units allocation the same way as when he
enters a task in Project Professional.
You have a project where resource A is 50% allocated. When you create
a task in Project Professional for this resource, the resource
allocation is set to 50%.
Create a task under the same project in PWA, submit and approve the
Open project professional and view the task information for the task
entered in PWA, why is the resource allocation set to 100% instead of
50% set for th...Enter formula by code.
can anyone help. I cant seem to get this to work.
I keep getting run time error 1004
application or object defined error.
Public Sub TLIdentify()
finalrow = Worksheets("INV Bookings").Range("B65536").End(xlUp).Row
Worksheets("INV Bookings").Range("AV26:AV" & finalrow).FormulaR1C1 =
Regards and Thanks for any assistance.
Francis Brown...Entering a dollar amount w/out having to enter the decimal
What is the formula to have Excel automatically enter the decimal so all I
have to enter is the numbers?
It's one of the options you can specify. In Excel 2007, it's:
Excel Options...>Advanced>Automatically insert a decimal point
"Julieanne" <Julieanne@discussions.microsoft.com> wrote in message
> What is the formula to have Excel automatically enter the decimal so all I
> have to enter is the numbers?
...How do I stop dates from being entered everytime I enter a number
Everytime I enter data in a box (ex: ages 5-9) I then press enter to go to
the next cell and it automatically puts in may 9 . I have tried putting in
general in formatting cells and it still does it. can someone help before I
shoot this pc out the window? I am making a population pyramid with males
and females and their ages.
Kicking and Screaming
You can precede your entry with a single quote...
....or format your cells as 'Text'.
Hope this helps!
In article <64AE5219-035D-46E3-9488-5D01F6B012FA@microsoft.com>,
Kicking and Screaming <Kicking and...entering time #2
wondering if there is any way to do this...
I have a column formatted for time as in this format 12:00
when entering a time it is cumbersome to have to enter the hour, then a
colon, then the minutes.
Is it possilbe to simply enter a 4 digit number such as 1245 and have it
show up as 12:45 ??
thanks so much... I've found this group to be irreplaceable...
glen in orlando
Enter your times without colons in column A and put this formula in column B
and format column B for "Time" in the form you want it.
"Glen i...Entering data
Please help me enter data into cells that seem to be
In article <firstname.lastname@example.org>,
"Alicia Contreras" <email@example.com> wrote:
> Please help me enter data into cells that seem to be
Tools > Protect > Unprotect
Hope this helps!
...I got 300 Leads in 4 Hours Using This
Let me guess...
You need more people to show your business to.
You need more people that are interested and ready to join and simply
send you money.
The problem is most corporate websites are NOT designed to give you
Now this new system will get you more leads than you can handle.
We offer cutting edge tools like video spokes people to get you "RED
We have even designed it so people will pay you to be a lead.
You read that right.
Not only will we flood you with tons of people that are interested in
business but they will pay you to be a lead.
T...converting days, hours and minutes to minutes
I do turn around times at work. The info is gotten from a report in
powervision ( a cerner product) and then exported to excel. The cells
populate this way (example) 01 15:15, the 01 is one day if there is no day
its easy to plug in a formula to convert to minutes but when there are days
01, 02 ect it wont convert. Does anyone know of a way to convert this into
minutes in excel? Or a way to average the days hours minutes? I used to be
able to export to comma and it would work but alas this is no longer the case
for some reason.
A1 = 01 15:15
Excel considers that a TE..."Enter Network Password"
Please help. I upgraded my OS to XP pro and outlook 2000. When ever
log in to outlook it continually asks for a password. I enter it, clic
"remember this password" and click ok. the box dissapears and come
straight back asking for the password I just entered!
I've tried everything to stop it including recommendations from th
Nothing seems to work. I've gone back to oulook express, tried outloo
xp and none of this works.
Anyone got any ideas?
----------------------------------...Enter Billing notes for Project Timesheets in Business Portal
In Business Portal, it seems that you can only enter notes at the timesheet
header level. In Great Plains, you can enter notes on each timesheet line.
How can I enter billing notes for each timesheet line in Business Portal.
Here are the instructions:
To add a billing note for hours that you worked on a specific day highlight or
click in the appropriate cell and then click Add billing note.
Charles Allen, MVP
> In Business Portal, it seems that you can only enter notes at the timesheet
> header level. In Great Plains, you can enter notes on each timesh...enter key and it requerys
is there a way when i press the enter Key i can get ti to requery
for example i have a search field, hit enter key and it requerys
you could place a Command Button on the form, and in the properties of
that Button, set the "Default" property to Yes. The Default button
on a form is what runs when a user presses enter.
Then in the "On Click" event of that button, you put in your code to
requery your listbox or whatever you may have.
Would like the enter key to go down one line & home. Is there something I am
missing in options. T"IA
In Christ's matchless name
ted & colleen
"ted" <firstname.lastname@example.org> wrote in message
> Would like the enter key to go down one line & home. Is there something I
> am missing in options. T"IA
If you use the TAB key to go across the columns, when you get to the end and
hit Enter, the cursor will do that.
> Would...Form just opened doesn't see data entered in previous form
I have one form displaying data from an organizations table (name and address
of organizations) with a subform displaying data from a contacts table (name,
address, organization phone, etc.).
The second form displays data from the contacts table with a subform
displaying data from the organizations table. When I enter an organization
in the first form and a contact in the subform of this first form then open
the second form (with a button on this form), the data entered in the first
form is not available. The data is present in the underlying tables but a
search in the organizations ...Excel keeps wrapping cells with text incl. alt/enter
I have a cell with multiple lines (alt/enter line breaks)
in a standard row where word wrapping is disabled.
So I see only the first line and that's how I want it.
Now, when I edit this cell the word wrapping gets
automatically enabled (checked box) and row height
gets adjusted to fit the text.
It seems alt/enter breaks auto enable the wrapping,
but what I need visible is a clean one line row no matter
what text I put in.
Any solution/workaround? I'm on excel2000.
higgs's Profil...entering null values
I am trying to do a conditional statement, and I can't quite get it right.
This is my formula:
=IF(G8>8, G8-8, null)
I don't know how to leave the cell blank if the condition is false. With
the present formula I just get the "#NAME error.
Try: =IF(G8>8, G8-8,"")
Use xdemechanik <at>yahoo<dot>com for email
"news.microsoft.com" <*> wrote in message
> I am t...Macro to select cells in column enter data then press enter
I need to create a macro and assign it a macro button at the top of the
worksheet (with the text Enter Hours) . This macro needs to select the cells
in Colum E (called Hours) enabling me to enter hours in, pressing Enter after
Can someone help me with a formula and how to record this macro?
Thanks in advance.
Excel has no way of knowing when to press ENTER while you are typing in a cell.
It does not know what is in the cell until you leave the cell.
Use your finger to hit the ENTER or downarrow key when you want to leave the
Gord Dibben MS Excel MVP
On Tue, 19 F...Enter Parameter Value when combo box selected
I have very little Access programming background and I am trying to
get the following to work:
I have a form: frmTenderDetails which has a bound control
ProposalRefNo to a table which displays the tender number for a
It has a subform that lists all the companies that have been invited
to tender for this job. I have a command button on the subform that
opens a form: frmTenderDocsReceived to display which documentation has
been received for each company in the subform.
frmTenderDocsReceived is based on a filter of the current
ProposalRefNo and shows this value in a tex...Entering data in Microsoft Excel
When we enter data with a negative sign i.e -28.00, we
prefer it to appear as (28.00) instead of -28.00.
Previously, once we click on the 'comma' sign at the
toolbar, we are able to see the amt with the bracket sign.
But now we are not able to format our newly created
worksheets to show the amt within the bracket.
Can somebody please help? For yr info, we are using
Windows XP & Office 2000.
Thank you very much.
"Serena" <email@example.com> wrote in message
> When we enter data with a negative sign i.e -...Trick behaviour when entering field
I have a form for which I want all fields except one to have the text in
entire field selected when that field get the focus. I know that I can
effect the behaviour entering field using a Database wide setting under
tools, options, keyboard, behaviour entering field. Is there a way to to
this for just one field on a form?
In either case, use the GotFocus event of the control:
Select it all:
Me.MyTextBox.SelLength = Len(Me.MyTextBox)
Start at the beginning with nothing selected:
Me.MyTextBox.SelStart = 0
Dave Hargis, Microsoft Access MVP
>...ctrl+shift+enter vs enter
what is the difference btw confirming with enter and ctrl+shift+enter
tkaplan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2298
View this thread: http://www.excelforum.com/showthread.php?threadid=37455
The difference is that for a normal formula you use Enter,
However there is a special kind of formula called an Array formula which can
only be entered using Ctrl+Shit+Enter. When doing so it will enter special
curly brackets to indicate it is an Array formula
_________...i enter value in one column the next column existing value turn 0
I am working same work sheet with two columns one is Anticipated Variation
cost and the other approved variation with corresponding total. when i enter
cost in approved variation the corresponding row in anticipated variation
column should auotmaticlly become zero.cna you help me out with the formula
"Bonnie" <Bonnie@discussions.microsoft.com> wrote in message
>I am working same work sheet with two columns o...