parsing a date and time field #2
I am having trouble parsing the date and time in a field. I download
data from a data base and the date and time come together in one
field. I want to seperate the two. The date and time comes across as
the following: "2/1/2009 14:37" in the cell. When I parse it, it
seperates into three columns as follows: "2/1/2009", 2:37 AM", and
"PM" I can see what is going on but I would like to get two columns
with one as the date and the other as the correct time. are they any
ideas on how to address this?
Try using the TimeValue and DateValue functions.
First format ...3.0 Customization
Is it possible in 3.0 to have one set of screens appear for one group of
users and another set for another group. For instance, could our
service people only see the service screens while our sales people only
see the sales screens? I know I can restrict access to different areas,
but we want to have a totally different look and feel for each group...
Sorry - I dont believe this can be done
"Matt Harvey" <email@example.com> wrote in message
> Is it possible in 3.0 to have one set of screens appear for one group of
>...Report CRM 3.0
I would need to find out the detailed procedure (step by step) to customize
Could anybody inform about any links or documents concerning this issue?
I'm not sure if it's detailed enough, but the technical training manual has
a section on creating and customizing reports. You can find it here:
Jeffry van de Vuurst
"Marco Rocca" <Marco Rocca@discussions.microsoft.com> wrote in message
news:CEF80683-EC26-456C-82C...Money Central Portfolio #2
My print function has gotten corupted. When I print it flips to WORD / format
and prints in a format that is 4x normal.
I am pretty new to using (or attempting to use) a Macro in a workbook. I am
having trouble following how and what to do to even start the process; ie If
there needs to be a worksheet already in progress or can I start from a new
THEN where to go from there.
Can I have some help in this area? Can some one supply me with a sample
Any help would be greatly appreciated
The best way to get started with macros is to use the Macro
Recorder. Go to the Tools menu, choose Macros, then Record New
Macro. Then, carry out some simple tasks and examine the code
that is produced.
How are statements sorted? Alphabetically by name or by account number? Does
Any help is appriciated, Deb
Mine are done alphabetically by name.
"Deb" <Deb@discussions.microsoft.com> wrote in message
> How are statements sorted? Alphabetically by name or by account number?
> anybody know?
> Any help is appriciated, Deb
...merging 2 cells without losing data?
How can I merge 2 cells without losing data from the other cell?
Not possible I'm afraid. Try placing the dat from both cells into one
and use "Center across selection" under Format>Cells>Alignment
Merge cells always end up causing grief. they are best avoided.
***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
"bob" <firstname.lastname@example.org> wrote in message
> How can I merge 2 cells without losing data from the other...how to config Server for one user which has 2 mail address.
we have one NT4.0 + Exchange 5.5 Server "A" Email email@example.com ��and
windows2003 + exchange 2003 Server "B" firstname.lastname@example.org user name is same in A
B��Mx record was be set ,question is how to config Exchange 2003 to receive
down the mail to Server A , because of we need to replace A with B.
thanks a lot.
E2K3 setup guides you through common scenarios (like yours) pretty much holding
your hand - on welcome screen tell it that you have existing E55 org and want to
join it, then follow on-screen instructions. Having usable backup of Exchange
databases and AD i...RMS Status Codes
Just wondering if anyone has a list of what the RMS Batch.Status codes 0-15
mean? I can't find them defined anywhere. I'm specifically looking at how
to identify Blind Closes so I don't count them in totals until they'e been
There is a Knowledge Base Article that covers the different Batch Status
codes from 0 - 31. Just search for 'batch status codes'
RMS Systems Inc.
"Zim" <Zim@discussions.microsoft.com> wrote in message
news:C72515DB-AD45-4C7D-B8DE-0A18E4A6D0D0@micr...clip ART #7
i AM HAVING TROUBLE DOWNLOADING CLIP ART FROM OFF LINE WHEN i DOWN LOAD IT AND TRY TO OPEN IN IT'S ALL FILE NAMES AND NO PICTURES JUST WORDS HELP
When you download from the ClipArt site the file is either .cil or .mpf depending on
your version. Double-click the package and the images will automatically go into your
Organizer/Gallery. You may have lost the association too, right-click the file,
properties, opens with... change, point to your Organizer/Gallery.
Mary Sauer MS MVP
"Janet Price" ...CRM 4.0 Custom Report Filter Problem
I am using the Report Wizard to create a simple report.
Report is using Quotes and Quote Products
I have a custom field in Quote Products which is a bit field Yes-No
When I use that field as a filter for report output, I get all records. The
filter criteria appears to be ignored
Is this an inherent problem with Report Wizard or Am I doing something
depends on your business logic and what you want to see.
If you have three quotes:
Quote-1 has three products, all with the custom field set to Yes
Q2 has three products, two set to Yes, 1 to No
Q3 has three products, all set...Lexmark driver for Windows Vista??
does anyone know how to get a driver for my Vista program for a Lexmark X75
Any help appreciated?
On Sun, 3 Jun 2007 15:07:39 -0500, "Kitty Stringfellow"
>does anyone know how to get a driver for my Vista program for a Lexmark X75
>Any help appreciated?
I'd suggest reposting your question in a newsgroup supporting Vista, or
Lexmark. This newsgroup is for questions about designing relational database
Queries in Microsoft Access.
John W. Vinson [MVP]
Here is one for you experts - I am a novice
I want to add a macro to a worksheet that will print selected information
held on certain rows of the worksheet.
Once the 'button' has been selected a mesage box will pop up asking the user
to input which row number he/she wishes to print.
On input that number is matched to the corresponding row of the worksheet
and that row is copied (without any formula - just cell values) and pasted
into another worksheet where it is placed into other formats and printed.
Seems like a simple(!!) job - but far to difficult for me to programme
Can an...Can you create custom activities? MSCRM 3.0
Is there a way to create a new custom activity instead of customising an
existing one? I have created a custom entity called 'Chat' utilising an
IFRAME. All works well but this entity really should be an activity
considering it's properties.
In fact I've just been introduced to MS-CRM 3.0 and don't really understand
what the difference is between an entity and activity. Would anyone shed the
light for me?
BTW, I think 3.0 looks great. Gotta admit it's improved.
In my experience, you cannot create custom activities. In fact, I have been
dire...invoice for envelopes with windows
What invoice template can I use that will consistently place the name and
mailing address on the invoice form so that it will always fit in the window
of an standard #10 business envelope?
There is no standard location for the window. I would suggest folding a
piece of paper and measuring where the window is on the envelopes you use.
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"Mary" <Mary@discussions.microsoft.com> wrote in message
> What invoi...Excel 2002 converts 'S' to 0 when pasting from Clipboard
I came across the following problem:
I copied some tabular data from IBM Personal Communications into the
clipboard (yes, I am still a user of good old 3270 applications). Then
I pasted the data into Microsoft Excel 2002 and all cells containing a
'S' became a '0' (number zero).
Next I did some tests and found out that every single uppercase 'S'
that is transferred to Excel using copy/paste is translated to '0'.
This would not happen with other letters or with words containing an
Using 'Paste special' I can choose to insert my Clipboard a...Sum amount if = 2 value's
I have a spreadsheet of payment types for which I want to sum the tota
amount per type per month
A B C
Type Amount Month
I'm able to get the total amount per type by usin
=SUMIF(A:A,"TYPE",B:B), but can't work out how to get a total for eac
type each month
Somthing along these lines: =SUMIF((A:A,"TYPE",B:B)&C:C,"MONTH")) ????
loscherland's Profile: http://www.excelforum.com/member.ph...How do I import from LotusOrg 6.0?Import command only has 5.0
I am trying to import my calendar data from Lotus Org V6.X. Under the file
command, it will only import from V5.X. Does anybody have any help for me
since I would like to convert to Outlook from Lotus Organizer.
DonAlbert <DonAlbert@discussions.microsoft.com> typed:
> I am trying to import my calendar data from Lotus Org V6.X. Under
> the file command, it will only import from V5.X. Does anybody have
> any help for me since I would like to convert to Outlook from Lotus
> ...Excel pivot table #2
i encountered an error in my pivot table.
i created an olap cube using the analysis manager.
the cube displays the correct data of my measures but on my
pivot report, it displays #N/A....
i need help to fix this one... thanks.... =)
...Only new email window?
Is there a way that I could have a shortcut on my desktop that does not open
the whole application, but rather ONLY open my new email window? I send out
a lot of email, and I also have a lot of other apps running.
Please let me know if that is possible. Thank you,
Steve F. <email@example.com> wrote:
> Is there a way that I could have a shortcut on my desktop that does
> not open the whole application, but rather ONLY open my new email
> window? I send out a lot of email, and I also have a lot of other
> apps running.
Create a shortcut whose target is:
"%Pr...Outlook Express 6 Spell Check #2
I am using Outlook Express 6 on Windows XP, and I have a
problem with spell check. When you send an email, it
says "spell check has been haulted, do you want to send
anyway" and if I ask it to spell check, it says an error
has occured in spell check. All my spelling options are
correctly set, so I don't know what the problem is.
Kimberly McNabb <firstname.lastname@example.org> wrote:
> I am using Outlook Express 6 on Windows XP, and I have a
> problem with spell check.
Ask in an Outlook Express newsgroup.
I'm new to Outlook.
I hear of an Outlook database in other threads. Is this synonymous with the
..pst or .ost files people mention?
Does it corrupt often and if so are there tools to repair it?
There's a utility called ScanPST.EXE that will scan and attempt to repair
Yes, typically when a user says Outlook database they're referring to their
"Craig Roberts" <email@example.com> wrote in message
> I'm new to Outlook.
> I hear of an Outlook d...unique with 2 columns
I have 2 columns with duplicates in the first column and no duplicates in the
second. I neeed to only see one value for each in the left and only one of
the accounts from the right.
ie: abc 1234
I would like to see either of the abc with the 1234 or 12345
I would like to see the bcd since it's individual with the 251
I would like to see either of the eft with the 600 or the 607
Use a totals query and one of the aggregate functions (First, Last, Min, or
Max) on the...host unreachable #2
if i send a email with a wrong address or mispelled it, i
don't get a message that the address, destination is wrong
until 4 days later after being deletedj from the outgoi
im using E5,5 sp4
Is that for all domains, even for Yahoo and Hotmail?
> if i send a email with a wrong address or mispelled it, i
> don't get a message that the address, destination is wrong
> until 4 days later after being deletedj from the outgoi
> im using E5,5 sp4
...Excel number formatting #2
I receive spreadsheets with separate columns of numbers
and text. The problem is that the numbers column is not in
number or general format (when sorting behaves like text).
Is there a way to turn those columns into numbers (except
stepping into each one separately)? When I just highlight
the number in the cell and hit enter, the cell
automatically becomes numeric (I'm looking for a more
You can do this:
1. Type 1 (the number 1) into a blank cell. Highlight this, select Edit,
Copy. Now highlight entire column(s) that you want changed to numeric, and