How can i use a command button to validate date and time
I have two command buttons, each on a different sheet. i need both of them to
put the current date in one cell on its sheet and current time in another on
its sheet. i also need these cells to be locked so the user can only edit
these cells by clicking the command button. Any answers?
...DTS Export fails on bad date
While trying to import an excel spreadsheet to a SQL Server table, DTS
fails, pointing to a column with date values. I have looked at all the date
values, and they appear correct. I need to get this excel spreadsheet
loaded to a database table. Is there any way to pinpoint the exact cell
causing the problem? Or, can you think of another way to export the data in
the spreadsheet besides DTS that might not be so sensitive to data content?
...Adding Space Between Rows?
I've imported a vocabulary list from Word into Excel, with one entry per
cell in column A, and I want to put a little space between the rows for
readability. In this case, I can't insert blank rows between the entry rows
because of the contents of another column. Is there a way to make Excel
increase the cell padding? Thanks to anyone who can help solve this
P.S. I'm using Excel 2000 in Windows XP.
"Joshua" <firstname.lastname@example.org> wrote in message
> I've imported a vocabulary list from Word into ...is the info in AD or Exchange?
Is the existence and location of mailboxes kept in AD or in Exchange?
So if, for example a user's mailbox location was changed and then
Exchange restored with a backup done before the move - will it work?
Will the mailbox be moved back to the old location or will the restore
On Tue, 30 Aug 2005 19:58:17 +0700, Peter Kaufman
>Is the existence and location of mailboxes kept in AD or in Exchange?
>So if, for example a user's mailbox location was changed and then
>Exchange restored with a backup don...How do I calculate escalation rates using dates and a set value
If I have a projected that needs to be escalated using start and completion
dates by a certain percentage per year, how do I write the formula. For
example if my project starts May 26, 2010 and lasts until may 26 2014 I want
to add escalation to midpoint at 4% per year.
...disc date for next month
We want to be able to choose a discount date for the next month the discount
is allowed. Our terms are 2% 10th net 15th. We can choose the due date for
the 15th of the next month, but we can't choose the discount date as the 10th
of the next month. All the invoices entered into the system from the 1st thru
the 10th calculate the discount for the current month instead of the next
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 me...combine text & date formula to show mmmm dd, yyyy?
How do I combine text and date formula to show the written date and not the
Excel number date? I have text in a couple of cells and a date formula in
another cell(input from a different worksheet). I have the formula =A3 & F3
& A4 in A1 and would like it to read: We went to the station on December 21,
2009 and took the train. However, it is reading We went to the station on
40168 and took the train.
Try something like this...
A1 = Today is
B1 = 12/21/2009
=A1&" "&TEXT(B1,"mmmm dd, yyyy")
Returns: Today is December 21, 2009
...Is there a way to copy and paste the date into worksheets
Is there a way to copy and paste dates into the worksheet withou
individually typing up each one
mark_vi_'s Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2450
View this thread: http://www.excelforum.com/showthread.php?threadid=38137
Is there a way to insert it the date into the the worksheet tab (not th
cells in the actual worksheet but the name of the worksheet itself
mark_vi_'s Profile: ht...Formaula for less than date and name begins with...!!! HELP!!!
IM trying to create a formula that gives me a total count for cells that are
less than 02/05/10 and the name begins with FHLM, heres what i came up
I keep gettin a bunch of ###### or 0, depending on how I move the data
"Senor Martinez" wrote:
> IM trying to create a formula that gives me...Adding the values on even rows/odd rows.
please refer to this post to prevent dupilcates
...Grouping dates in pivot table
I am pulling data from a SQL Server database to create a pivot table.
Excel (07) is not recognizing the field as a date. This is a field I
would like to group by in the pivottable. I am aware of all the
techniques to convert this to a date field, but I am searching for an
answer as to why XL pivot tables cannot consume the dates directly
from a sql query.
I have played with bringing the dates back in a number of differenent
formats with no success.
Any insights into this would be appreciated.
Probably coming in as text and yuo may only need to copy an unused cell and
paste sp...how do i change dates on my calendar and keep my pics
Publisher doesn't support this. You would need to do it manually.
Microsoft Publisher MVP
~pay it forward~
This posting is provided "AS IS" with no warranties, and
confers no rights.
"Bob T" <Bob T@discussions.microsoft.com> wrote in message
...Looking up a date
Trying to get this to work, but no success:
The value in A6 is a function; not hard-coded.
It seems to work with one date and one result vector, but not two, and
ultimately I will need several, maybe 7 or 8.
You can't use functions in array constants.
>ultimately I will need several, maybe 7 or 8.
Why don't you just create a table in ascending order by date:
.............A.......Echoing keyboard input on a CEdit box
I have a CDialog object that has a CEdit data member, and numerical
button resources. What is the best way to echo the corresponding number
button pushed on the CEdit box, that is, just like in a calculator?
That would be to get the text from the edit control, add the new char to it
and then set the text again.
Text += CString(nChar);
"Zilla" <zilla62XSPAM@bellsouth.net> wrote in message
> I...Format Date 05-28-10
How do I format the date to show May, 2010? The closest I can get is May-10
from the drop down list.
> Hi, all,
> How do I format the date to show May, 2010? The closest I can get is May-10
> from the drop down list.
Custom date format:
Custom Format mmmm, yyyy
Gord Dibben MS Excel MVP
On Fri, 28 May 2010 09:05:01 -0700, Malcolm
>How do I format the date to show May, 2010? The closest I can get is M...Adding VLOOKUPS across multiple worksheets
I am trying to add several VLOOKUP results obtained from data in several
worksheets. My formula is : -
=VLOOKUP(A5,'Common Costs - Budget'!A5:X74,2,FALSE)+VLOOKUP(A5,'Brighton -
Budget'!A5:X53,2,FALSE)+VLOOKUP(A5,'Hove - Budget'!A5:X56,2,FALSE)
I have several worksheets all with similar budget information on and, for
example, I need to all the payroll costs from each of the sheets. Not all
the sheets will always have costs on so I was thinking of doing lookups and
adding them together but I just keep getting the #N/A result. Is there a way
to...Formatting a # to auto + 1 when adding new info- not autonumber th
Sorry I am slow with all this and don't know VBA...I have a table that
currently has a field name "CI#" with the data type as "number" with a format
of "0000"- when I enter items into the form based on this table, I always
manually enter the numbers (the numbers are YYNN)...I would like it to
automatically add "+1" to it. I understand from reading changing this to
autonumber is bad. So how do I do this?
Thank you so much,
Search on-line for "Custom Autonumber".
The general gist is that you'...Excel Date Formatting
In Excel the regional settings are set to short date
format. However, if you try and format cells individually
with a date, the date changes, but when the spreadsheet is
closed and the reopened the formatting reverts to the
short date format! We are using Excel 2000 with sp3 on XP
(If thats any help!) If anyone has any ideas why this is
occuring i'd love to know!
Are you saying that the same person on the same pc opens the file and the date
format has changed?
If it's another user (or another pc), then it could be the way excel picks up
the date format if ...SRS Default reports currency and date format
I have installed the SQL Reporting Services default reports supplied by
Microsoft, which is very useful for the customer. However, I would like to
know how to I change the date format and currency symbol on the reports. It
currency displays the currency as '$', but we are in South Africa and the the
date format to dsiplay dd/mm/yyyy and the currency to be 'R'. My regional
settings are set correctly and the data within Dynamics displays correctly.
You will need to change the Properties of the fields in question on the
report itself. Ope...Adding Contacts When Replying
I am using OL2003 and I do not seem to be able to figure out how to add
senders' email addresses to my contact list or address book when I reply to
Other than MapiLab, are there any other good Add-Ins or Third Party
Utilities that will automatically add senders to my contact list or address
book when I reply to their message?
gfr92y at yahoo dot com
Please see my response to your post in another group.
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
and Micr...Adding a line after a date
I have a file that I am trying to sort and add a line between years. This
file is 36,000 lines long and holds multiple records by a specific
identifyer. The problem is I have multiple records per year and I only want
the file to put a break after each year not each date.
Please help! :-)
Thanks in advance
Use a helper column with this formula copied down, then Copy > Pastespecial
> Values to get rid of the formula......then do your line-insertion based on
Vaya con Dios,
"Mpls501sMan" <Mpls501sMan@discussions.microsoft....Printing only added items on Orders
Hello all, this is my first post, I'm new to GP. (Pro ver 9..)
If an Order has already printed, and I add additional line items, is there a
way to print ONLY items that have not been printed prior, on the Pick ticket
and Packing list ?
For example: I create Order for one item, print. Add another item later,
print, only want the second line item to print. Add another line later,
print, only want that third item to print.
Is that an option I can select ?
SImilar to what is available from the "Print Sales Doscuments" window, where
it allows you to s...CRM release date
would you please help me know th release date for MSCRM version 1.2?
1.2 has been available for some time - it is the current release.
"marwa" <email@example.com> wrote in message
> Hi there,
> would you please help me know th release date for MSCRM version 1.2?
Thank you for your reply, but i want to know the exact date, when it is
> Hi there,...Problem with dates in a DAvg query
Could someone please tell me why the following section of code gives -317
days average dwell when there is only one part, (for info [Date Raised] is
24/11/2000 and [theMonth] is 01/11/200)?
DwellAvg: CInt(DAvg("datediff('d',Dateserial(year([Date Raised]),month([Date
#" & DateSerial(Year([theMonth]),Month(DateAdd('m',1,[theMonth])),1) & "#)",
Could it be something to do with UK/US date formats and if so how can I
I know it is a problem in this part of the code as the query gives the
correct count of e...Change date formats on cheque
We are using payable cheques with the stub on the top. We are trying to
modify the date to ready dd-mmm-yyyy. I have followed the instructions in
except to change the table name becuse I am on 8.0. This will print the month
format as "september" what I am looking to do is have it read the alpha short
form of the month (ie - Jan, Feb, Mar......) Is there any way to accomplish
this? It currently is working and printing the full month. I am just
interested in getting the short form of the month to print. ...