how to convert date
I'm looking for some method to convert mail date, in format:
eg. "Sun, 18 Sep 2005 20:57:08 +0200", to computer local time.
I tried CTime but without resoults.
Have you tried COleDateTime::ParseDateTime()?
> I'm looking for some method to convert mail date, in format:
> eg. "Sun, 18 Sep 2005 20:57:08 +0200", to computer local time.
> I tried CTime but without resoults.
>I'm looking for some method to convert mail date, in format:
>eg. "Sun, 18 Sep 2005 20:57:08 +0200&qu...Comment Font #2
Where do you chage the font default for a comment box. Each time I insert a
cooment box into excel, it defaults to a font size of 8 and I have to change
it to read it. Where is the setting to change this to a different font
I am using Windows XP and Office 2003.
Thanks for the help.
Visit Debra Dalgleish's site:
> Where do you chage the font default for a comment box. Each time I insert a
> cooment box into excel, it defaults to a font size of 8 and I have to change
> it to read it. Where is th...Xml2PDF version 2.3 with support for WordML is released
Xml2PDF formatting engine version 2.3
May 25, 2004
Altsoft N.V. is proud to announce the release of version 2.3 of its
Xml2PDF formatting engine.
The update includes:
- WordML as a new input format;
- support for fo:float in XSL-FO;
- improved word and line stacking in all formats;
- side floating is available in XHTML;
- images can be used as a pattern in SVG;
All editions of Xml2PDF formatting engine, which include Workstation,
XmlSpy Plug-In, Hotfolder and .NET API, are automatically updated.
Altsoft Xml2PDF is a .NET based formatting engine for converting
various XML-base...Convert text to time value
I have a series of time values in a 'General' format. They are of the
Which is 18:45:25 or 6:45:25 pm.
A time which is am would be of the type:
Which is 1:23:45 am.
Is there a way to convert those 'General' values to an Excel serial so
that I can figure out the difference between two times? I've seen a
bunch of examples on the net, but none of those that I have found deal
with this format that I can tell.
"Andy" <firstname.lastname@example.org> schrieb...You a 7-Day FREE Trial #2
We Are Offering You a 7-Day FREE Trial to the internet's Hottest New
If you missed out on the DOT COM boom, now is your chance to cash in
on the massive and growing global demand in our $20 BILLION PER YEAR
market. We'll show you how to create an income that will come to you
for years and grow with each passing month.
A SIMPLE, Fully-Automated, REJECTION-FREE Internet Marketing System!
Finally, an EASY, proven, FREE system that will truly help anyone
willing to follow our guidance succeed!
Average People Are Making Money! Average people are putting their
home...How to Convert UTC to localTIme(C# )
I have got the value of user account's lastlogon time. Its type is Int64.
This value is stored as a large integer that represents the number of 100
nanosecond intervals since January 1, 1601 (UTC)(Refer to MSDN).
I don't know how to convert this value to localTime.
The following is my code.
DirectoryEntry deUser = new DirectoryEntry(ldappath);
DirectorySearcher src = new DirectorySearcher(deUser);
src.Filter = "(&(objectClass=user)(SAMAccountName=" +
accountNa...CAN'T SEND EMAIL IN OUTLOOK #2
I downloaded some updates from microsoft and, if I open a site and click on
"file" then 'send to", instead of the "send" button, I get a message "email
blocked because of attachment".
How can I get rid of OUTLOOK so that I can just use my simple OE6?
Simple, you stop using outlook and set up / configure OE
To be doubly sure you can uninstall OL
"XJS FAN" <XJSFAN@discussions.microsoft.com> wrote in message
>I downloaded some updates from microsoft and, if I open a site and...Excel: Auto converting text to numbers
I am downloading an Excel sheet, and the numbers come in as text. It
basically comes in as "33 %" but Excel registers this as text, not a
I have a cell that will be used to add the numbers, but since they are
text it doesn't work.
Given this information, is there a way to convert the imported data
into numbers. I would prefer to include this into my formula. The
potential numbers are:
0, 1, 2, 3, 4, 0 %, 25 %, 33 %, 50 %, 67 %, 75 %, 100 %, and N/A
I would prefer a function, again if possible, that could convert any
number. Please note, the space between the nu...service pack 2
I jave install this update mulpitle time do a reboot and the system tells me
that it need to instll it agian
each time it say successfull
Please always state what OS you're & service pack
Also, could you supply some information on what your firewall is, what is
the installed antivirus/security suite, other R-TP programs, e.g. Spybot
Search & Destroy (reduced functionality called "TeaTimer") Avira (From
version 9) (Included in antivirus package), Ad-Aware, etc?
WinXP SP2, Vista SP2, Win2K SP...How do I convert dates to text keeping the format?
I'm trying to convert a column of data in date format *m/d/yyyy to a text
format without converting to serial numbers. Ie: I want to retain the
mm/dd/yyyy format. Is there a way to do this?
"sprlarry" <email@example.com> wrote in message
> I'm trying to convert a column of data in date format *m/d/yyyy to a text
> format without converting to serial numbers. Ie: I want to retain the
> mm/dd/yyyy format. Is there a way to do this?
That ...CRM1.2 on SQL 2005
Does CRM 1.2 support SQL Server 2005 standard edition?
I am trying to install and get the following error:
I'm trying to install Microsoft CRM server 1.2 on Server2003 with SQL
2005 and get following
installation error during install:
"Setup was unable ot install Microsoft CRM Server.
Setup was unable to create the Microsoft CRM databases.
Failed to run script:00 - create mscrm.sql. HRESULT:80040E14.
Unknown error. (80040E14)."
"Chris" <firstname.lastname@example.org> wrote in news:1153695510.955617.243440
> Does CRM 1....how to convert excel's .cvf file to .csv file
...1 Cell 2 Values?
Is it possible in excel to have it return two values in one cell separated
by a comma and spaces?
For example I want it to count the number of times in a month the value was
positive and the number of times a value was negative and in the cell I want
it to show
A1: +, -
Is this possible?
Thanks to all,
>Is it possible in excel to have it return two values in one cell separated
>by a comma and spaces?
>For example I want it to count the number of times in a month the value was
>positive and the number of times a value was negative a...Graph and Cell References
I am looking to create a graph, that references cells from two different
worksheets for the same data set.
I would use part of one of the sheets (or a third possibly hidden sheet) to
consolidate the data with formulas such as =Sheet1!A5 and =Sheet2!G2
Now make the charts anywhere you wish from the consolidated data.
remove CAPS in email address
"balandino" <email@example.com> wrote in message
>I am looking to create a graph, that r...Convert Access97 to 2000
Hello, we're currently running access97 and would like to convert it to
2000, but we don't know what is the administrator password for this
database. Also this database is running on multi user and have difference
permission for diffence users. Could someone help me how to do make this
happen but keep the currently permission retaint. Thanks
...change case of text #2
Some recent data was imported to an Excell worksheet that
had a large amount of text in capital letters. Is there a
way to change this data to "PROPER" throughout the entire
Gloria Anderson at Habitat for Humanity of Key West and
the Lower Florida Keys
will do the trick
"habikeys" <firstname.lastname@example.org> wrote in message
> Some recent data was imported to an Excell worksheet that
> had a large amount of text in capital letters. Is there a
> way to c...Convert 2000 Calendar to web page
When I convert my calendar for 2005 to a webpage, the page is off by 1 day.
Is there a template or fix available to fix this?
I can edit the html file but this should not be the case. Fixes?
Suggestions...other than use Apple?
"Duane Perry" <email@example.com> wrote in message
> When I convert my calendar for 2005 to a webpage, the page is off by 1
> Is there a template or fix available to fix this?
...XML Note convert to DataSet
I have this function:
object acmResponse = acmLogin.acmString("4001", "", paramFormLogin +
paramUserBasics);System.Xml.XmlNode acmNodes =
What I have todo, to convert the XML Object in the DataSet Object?
Is it possible to convert a Money file created in the USA version to that of
the UK version?
Thanks in advance
The general way is QIF Export then Import. It's involved and has limitations
like loan accounts don't QIF. See http://www.bollar.org/msmoney/#Q1.
"Crispy" <firstname.lastname@example.org> wrote in message
> Is it possible to convert a Money file created in the USA version to that
> the UK version?
...In POS 2.0 Under Reports the Custom is Greyed out
Why does POS 2.0 Have a custom option under reports but not let me access it?
I am logging in with owner rights and it is still greyed out. Is there
someway to activate this feature?
The custom option is for the custom reports that you write.
"Brad D" wrote:
> Why does POS 2.0 Have a custom option under reports but not let me access it?
> I am logging in with owner rights and it is still greyed out. Is there
> someway to activate this feature?
I am needing a custom report. I guess I am needing some insite into how to
write them and where to save them.
"tommyv...Problem converting from Quicken to M2005
My Quicken files are mostly investment related, and generally
converted fine. However all bonds (regular and muni's) converted as
Investment type: Mutual Fund, not Bond. (1) How do I prevent that, (2)
How do you change the Investment Type for an item? Thank you.
In microsoft.public.money, Mike wrote:
>My Quicken files are mostly investment related, and generally
>converted fine. However all bonds (regular and muni's) converted as
>Investment type: Mutual Fund, not Bond. (1) How do I prevent that, (2)
Money typically converts custom data types from Quicken into funds.
I thou...Relative sheet reference
Is there a way to reference sheets not by itn's name but by its
1st sheet name = 'Report'
2nd sheet name = 'Data1'
3rd sheet name = 'Data2'
I'd like to refernece data in sheet 'Data2' relatively. Somthing like
dim rng as range
set rng = worksheets(3).range("A4")
> Is there a way to reference sheets not by itn's name but by its
> relative position?
> 1st sheet name = 'Report'
> 2...Numbers converting to decimal
I a trying to figure out why when I type 11 and
automatically converts it to .11, if I type 11. it will
stay 11,if I change all the cells to text then back to
number they willstay.
I have checked the formatting of the cells, it even
happens when I open a brand new worksheet.
Tools>Option>Edit, uncheck Fixed Decimal
Microsoft MVP - Excel
"DawnP" <email@example.com> wrote in message
> I a trying to figure out why when I type 11 and
&...2 Exchange servers 5.5 in the same site.
I have a weird case over here and I don't know if it normal. I would like
to hear your experiences and if there a solution.
The case is that I've always had only one exchange server (version 5.5)
and recently we added a second one. When we send an email were the sender
and the recipients are in differents servers it takes about 10 minutos to be
delivered (the sender does not perceive it, the email leaves his PC
inmediatly). Is there a reason for this behavior?
We have both servers in the save LAN connected to the same LAN Switch.
"Ale...linking comments to appear in cell at same time
Is it possible to have comments for cells, appear in a seperate cells or
worksheet as data as they are added like link function ?
I have tried in some other work a code similar to the following code in vba
Range("d2") = Range("a1").Comment.Text
but I am not aware whether it can be linked. perhaps a event code with
sheet_change can be attempted.
MarkM <MarkM@discussions.microsoft.com> wrote in message
> Is it possible to have comments for cells, appear in a seperate cells or
> worksheet as data as t...