Name, Date and Address Formats
I have a number of different spreadsheets that I need to impirt into a
single database. Unfortunately some of the information is in different
Would anyone be able to provide me with a solution that can turn:
A B Brown
*A B C*Brown*
Brown, A B
Brown, Anthony Bernard
Brown Anthony Bernard
Mr A B Bernard
Into separate fields for title, forename, initials & surname
On a similar theme I also need to do much the same thing with
1 Victoria Road, Victoria, Victoriashire, VC1 1VC
And lastly (for now anyway) I also have some dates that I need to
...Short / long date format bug?
The computer is set to use the long date format and everything is OK until I
make changes to a chart which causes all dates in all open worksheets to be
displayed in the short date format. When excel is closed down and restarted
the problem is resolved - but doing this is annoying.
I can't see if this a known fault or if it has been introduced through a
Does anyone know anything about this strange behaviour please?
Since posting this I haven't had one response. I can't believe I'm the only
user experiencing this problem. Every time I...Compare this year/qtr/mo to date with prior year/qtr/mo to date
I'm trying to create a report that compares revenues received this
year/qtr/mo/wk with revenues received last year in the comparable
year/qtr/mo/wk, and additionally by sales division and sales manager.
I have the data stored in a table with fields: SlsDivID, SlsMgrID, DtRecd
and AmtRecd. I know I will need to use the date part function, but am not
sure how to get the info in the report I need.
format should be:
SlsDiv - SlsMgr - CY YTD - LY YTD - G/L and % - CY QTD - LY QTD - G/L and %
I have tried pivot tables (not working) and various group and total
functions (a...Can Excel express a date with ordinals?
Wondering if excel can express mmm dd dates including their ordinal?
Examples are: May 4th, October 1st, June 3rd.
For a date in A1:
=TEXT(A1,"mmmm ") &
MS Excel MVP
"Wendy D" <WendyD@discussions.microsoft.com> wrote in message
news:054E5E93-3B1B-4311-AB49...I am looking for a function for linear interpolation
I am looking for a function for linear interpolation
Look in HELP for the LINEST() function
Microsoft MVP - Excel
"azad" <email@example.com> wrote in message
>I am looking for a function for linear interpolation
...Excell & MailMerge dates
I have an excel file with dates broken down with a cell
for the number in the month, a cell for the month, and a
cell for the year. I used the "MMMM" for the month. In
excell the cell reads "July", but when I use the cell as a
data cell for mail merge in WORD I don't get the month I
get the date number. Is there a way to get WORD to read
From a previous post:
You could use some helper cells and create strings for each field--then use
those helper values:
=text(c1,"#,##0.00&q...Date Format turn to Year #2
From: firstname.lastname@example.org - view profile
Date: Thurs, Nov 16 2006 9:24 pm
Email: "learning_co...@hotmail.com" <learning_co...@hotmail.com>
Not yet ratedRating:
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse | Find messages by this author
I tried to convert the date to YEAR and then the year plus 25 Years
=3DYear(A1) I'm getting the result 1900 instead of 1965.
I tried to add 25 years later to 1990 from 1965.
Your help would be much apprecated...Input Mask for Dates
Can I apply an input mask or custom format to cells so
that users do not have to type the slashes for date
have a look at
This requires VBA as this can't be done with formating only.
> Can I apply an input mask or custom format to cells so
> that users do not have to type the slashes for date
> entry? Thanks!
You can use some VBA code that will interpret a date that
is entered with out "-" or "/". See Chip Pearson's site:
...USA to UK Dates
I have a list of data extracted from elsewhere and the dates are in USA
Can excel swap this around to UK format dd/mm/yyyy ?
thanks in advance
Now: YZF-R1, CBR1100xx-x
Then: A100, MBX80, XL125, CB400, FZR600, CBR600Fv
Format the dates to dd/mm/yyyy
Highlight the dates
Format > Cells > Number tab > Date > choose the one you need
If it is not in there go to Custom and put dd/mm/yyyy in the space
provided under Type.
-------------------------------------------------...Use combo to print report between two sets of dates
I am trying to print a report that shows timesheet entries for two sets of
dates. The report also prints out based on the data entry person selected.
The user selects their name and then uses another combo box to select pre
My code is as follows:
Private Sub cboDates_Click()
Dim stDocName As String
Dim FromDate As Date 'Name of criteria start timesheets date field.
Dim ToDate As Date 'Name of criteria end timesheets date field.
Dim FromOTDate As Date 'Name of criteria start OT date field.
Dim ToOTDate As Date 'Name of criter...Service Appointment, Activity History, and "Due Date"
When I create a service appointment in CRM, and I check the "All Day Event"
check box, the schedule start and end times disappear, and the dates sync.
This seems logical. However, when I look in the activity tab or the history
tab the "Due Date" displays the next day.
For example, I create a service appointment where the scheduled start date
is 2/10/2007, and I select the "All Day Event" checkbox. The scheduled end
date is set to 2/10/2007, the duration is set to 1 day, and the time fields
disappear. If I view this service appointment in the activities ...How can I look in a sharing folder of another computer?
I have a home network of 4 computers - 2 WinXP, Vista, Win7. The network
works normally. I can easily look in a sharing folder of another computer by
my Total Commander. But I made a bootable BartPE CD. After booting from the
CD I can get online and browse any sites around the world, but I cannot look
in a nearby computer folder! Every time I get the following message.
"Workgroup is not accessible. You might not have permission to use... "
How do I fix this problem?
"Levlg" <email@example.com> wrote in message
news:4ba0b9b4$1@d...Dates in Excel 2007 graph axis dialogs
I work for an environmental engineering firm, and commonly create time-series
and other scatterplots of numerical data using Excel.
In Excel 2003, I could format a time-series scatterplot axis minimum and
maximum easily by typing in the dates in short date format. Not so in 2007 -
it refuses to accept dates in anything but "days elapsed since 01/01/1900"
Is there a workaround for this? Why was it changed? It was quite useful.
Overall, I'm pretty unhappy with the new Excel. It seems to have acquired a
lot more layers of very questionable usefulness. Many of...Using a query versus a table for the look up wizard
I have a field which I would like to use the lookup wizard for to generate a
drop down list for the user to select from.
My question is whether my databse would run faster if I used:
a query from an already established table as the values for the lookup
to build a new table to hold the information for the lookup wizard to use.
I think you'll find few of us recommend the use of the Lookup Wizard. Lookup
fields only have a place in tables, and your users should never be working
directly with the tables. Create a form, and use a combo box on the form.
(See http...chart with dates on the x-axe
how can you change the x-axe into a text x-as when the data are dates ?
on specific dates a want to show a specific value. When I want to
create e.g. a line-type chart, the values are ok, but the x-axe with
the dates becomes a time-ax in stead of showing the real dates from the
Is there a way to change the dates into text, without making it
explicit text (with a ') because I want to use them also for
chriske's Profile: http://www.excelforum.com/member.php?action=getinf...Date Entry in Excel 2000
We recently upgraded to 2003 and one of our users says she
was able to enter a date such as 10/24/04 in Excel 2000 as
102404 when she had the cell formatted as a date. I
haven't been able to reproduce it on a 2000 machine nor
does it make sense to me that it would work given that a
date in Excel has a numeric value which is unrelated to
the digits in the date.
Is she mistaken or is there a setting I don't know about
which allows this?
She's most probably mistaken. That behavior isn't native to XL. It's
possible to do this with event macros...How do get the years and days Between two dates
if you had 5/1/2006 and 2/28/2002 how would you get 4.17?
If 5/1/2006 is in A1 and 2/28/2002 is in A2, then maybe:
But if you're trying to find differences between dates, you may want to take a
look at =datedif().
You can find lots of info at Chip Pearson's site:
(=datedif() was only documented in xl2k's help.)
jhon doe wrote:
> if you had 5/1/2006 and 2/28/2002 how would you get 4.17?
...Look up values and place in spreadsheet
I have an excel workbook with two sheets.
On Sheet2, in column A is employee name. In column B is comments about that
employee. The employee's name could be repeated several times throughout the
workbook. Sheet2 has 1000 rows with multiple employees on it.
On Sheet1 I want to put all the comments that match Employee1 (which is in
cell A1 on Sheet1). There will probably be 20 matches, so I want the
comments to be in rows 2-21.
Is this possible?
Thanks in advance.
Try this *array* formula in A2 of Sheet1:
=INDEX(Sheet2!$B$1:$B$30,SMALL(IF(Sheet2!$A$1:$A$30=$A$1,ROW($A$1:$A$30))...dates as minimum axis values
Excel versions prior to Excel 2007 allowed dates to be entered as minimum
axis values for XY charts on the axis format scale menu. In Excel 2007 when
I attempt to enter a date as a minimum value, i.e. attempting to enter
1-1-2007 with the Fixed radio button selected in Axis Options, the automatic
value pops back up unchanged. I can successfuly enter a numeric value, but
not a date. This requirement adds several extra steps - calculating a date
value and typing the resulting number, then deleting the calculation - to
what used to be a simple process. If anyone knows that the same cap...Automaticaly put in the / in a date field
I want my users to input a date in the format dd/mm/yy
I know some of them will mis out the separators and enter for example
140301 for the 14th March 2001, but Excel changes the date to something
How can I create a mask (like in Access) so the separators are already
displayed in the cell? For example the cell would look like / / and
when the date is input it automatically jumps over the separator.
You could use a worksheet event that changes the entry to a date. Chip Pearson
has some code at:
> ...Extraction of Dates
Hello...I would appreciate any help. I have database that I am creating and
one of the tables contains SessionId (unique), StartDate, and an EndDate.
This data comes from a data logger. There is also another table connected to
this table that records a sound code at night, and a date if sounds were
heard (within those session dates). However...if there was no sound...then
that date does not get input. What I would like to see is an output of all
the dates (from the StartDate to the EndDate for each session), whether or
not there was a sound or not. How do I generate a popul...how do i create reminders in outlook from a date cell in excel?
I need to know how to create reminders in outlook from a date cell in excel?
Try posting in an Outllook forum. Maybe they will be more helpfull.
Greetings from France
"Philhegele" <Philhegele@discussions.microsoft.com> a écrit dans le message
>I need to know how to create reminders in outlook from a date cell in
...How to add the date after the "A1"
I type "The information gathered as of March 9, 2008" on cell "A1"
Is there a way to make a date default like
"The information gathered as of " & Date (default).
Your help would be much apprecated.
="The informations gathered as of "&TEXT(TODAY(),"mmmm d, yyyy")
Microsoft MVP - Excel
<firstname.lastname@example.org> wrote in message news:email@example.com...
| I type "The information gathered as of March 9, 2008" on cell "A1&q...sort by date #2
I am trying to sort by date where formatting is 'yyyymmdd'
and the months are December, January, February, and March.
The months need to show in the above order.
Thanks for helping with this..
Create a helper column with a ranking as you see fit such as
=IF(MONTH(G1)+1=13,1,MONTH(G1)+1) and sort by the helper column.
"Red" <Red@discussions.microsoft.com> wrote in message
> I am trying to sort by date where formatting is 'yyyymmdd'
> and the months are December, January,...Target Date for Entourage Integration with Outlook
I recall reading something from Microsoft that a new Outlook is in the
works that will replace the Entourage but can't remember the projection
for when this event will take place?
> I recall reading something from Microsoft that a new Outlook is in
> the works that will replace the Entourage but can't remember the
> projection for when this event will take place?
According to the Mac Mojo blog, it will be released with the next
version of Office for Mac, which is slated for release "Holiday 2010".
We can probably assume this refers to t...