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...Conditional formatting if condition of an if statement is true and a string value is displayed
I got a nested 'IF'-Formula in an excel cell that returns nothing if
the condition is false.
I would like to conditionally format this cell with grey shading if
the condition is true and a string value is displayed.
How can this be achieved using excel conditional formating
Help is much appreciated. Thank you very much in advance.
Let's say your doing this conditional formatting in cell K17. In
conditional formatting (xl2003) choose the FormulaIs: option and enter:
choose your formatt...Format cells #7
I have Excel 2000, Win ME. Recently the pulldown command to format cells
does not always respond - ie, no box appears, so I can't apply borders or
control number format. The shortcut approach doesn't work either. I've
tried Help..Detect and Repair but the fault remains. Any suggestions
...Hyperlink behavior Word 2007: correct page but wrong part of page
I've searched a lot of place but have not even seen anyone else having this
Document is a multi-page Word 2007 form template with hyperlinks for
In most cases clicking a hyperlink will take you to the correct page, and
the top of the page displays. However on some pages, it either displays the
bottom of the page and/or the top of the next page. Sometimes the cursor is
in the first form field of the following page.
With the template open, view field codes, show bookmarks and show text
boundaries, I still can't see what might be causing this behavi...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" <email@example.com> schrieb...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...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" <firstname.lastname@example.org> 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 ...CHm file format
I have seen your's reference on code project. I am new to CHM format and i
create a CHM viewer. I have some queries regarding the same
a) what is binary TOC and binary index ( I have been able to parse the HHc
and HHk fie). How i should parse the same
b) What are merged files. How i can read them
c) How how CHI, CHw and CHQ files can be created. How reading of these files
will be different form the reading CHM file.
Please help me out by answering my queries.
...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...Cell Formats (like StyleSheets)
Operating System: Mac OS X 10.5 (Leopard)
I cannot find the way to store some characteristics (font, size, ....) of cell-formatting to own formats (like stylesheets, for reusing them) <br>
There are just 6 standards and I cannot add more. <br><br>Any ideas?
Sure you can :-) Where are you trying?
The easiest way is to format a cell the way you want the style configured
then while the cell is selected go to Format> Style. Just type the name you
want the style to have then click 'OK'.
Alternatively, go to Format> S...how to convert excel's .cvf file to .csv file
...How do I create the mirror image of any written word?
In any Word document, is there a method of creating a mirror image of any
Your question would probably get a lot more help in a MS Word forum rather
than this one (PowerPoint).
WordArt and flipping would be one way, but without knowing the version you
are using, it's hard to give much more help. When you repost in a more
appropriate forum, give them some information about version and what it is
exactly you are trying to accomplish.
Bart: "According to creationism, there were no cavemen."
Homer: "Good riddance! Their drawings sucked ...word 2007 won't reg key
newer dell computer with OEM vista home premium installed.
unable to activate word using reg key stated on the computer. tried at least
10 times, but dialog box indicates error. did bypass activation & opened a
few new word docs, but when i copied some old data files into word 2007
everything locked & unable to update. still using old computer & moving some
data files to the new. able to get automatic window updates though.
Thanks to Dell support, the number on the box was incorrect & had to use the
number on the installation disk included in the package of i...Built in excel 2007 formats via VBA
Does anyone know how to format a line using excel 2007 built in presets via
vba, as the macro won't capture them?
Thanks and regards, Mark
To figure this out for yourself, see
Case Study – Embedded and Linked Objects
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu
"mark Stephens" wrote:
> Does anyone know how to format a line using excel 20...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
...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?
...Format a concantated text string
Sorry if this is boring but I'm stuck.
I have a cell that counts something, it also has a piece of text at the
front of the count but I want the count to be formatted as currency and
I've tried ="Major "& Format(COUNTIF(C:C,"Major")*245****) but I can't
get it right and think it's a VBA command!
"Bob Phillips" <bob.phillips@notheretisca...Convert
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?
...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...Conditional formatting in Excel_Strange behaviour
Hi to everyone.
I have a column in an Excel sheet , let’s say A1:A10 where
A1:A10=1,2,3,4,5,6,0,ABC,9,10 and all the cells of A column have been
declared as text.
I would like to apply conditional formatting with multiple criteria as
1) = not(isnumber(value(A1))) the cells to change in red color
2) = value(A1)=0 also the cells to change in red color
(These conditions must be apply in all cells A1:A10)
When apply these conditions separately it works fine and the cells 0, ABC
become red at the same time.
When apply these conditions in one line as follows:
Or (value(A...Auto Format
I am writing reference ranges in columns for lab tests and am having a
problem. In the column i want to write: 10 - 20, but everytime i change to
another column it changes to Oct 20. This is getting on my nerves. What do i
do to prevent this?
Format those cells as Text. Right click the cell or range of selected cells,
select Format Cells, and then on the Number Tab, select Text.
> I am writing reference ranges in columns for lab tests and am having a
> problem. In the column i want to write: 10 - 20, but everytime i change to
> another column...My keyboard is locked up in a Word Document
I can't backspace or type any letters or numerals in a word document but the
keyboard works fine in excel, etc.
If this happens in new, blank documents, exit Word and rename the normal.dot
file (normal.dotm if you are using Word 2007). To find the file, you can
search for it in Windows; be sure to search hidden files and folders.
If this happens with a particular document, only, it might be protected or
Microsoft Word MVP
"SK Teacher" <SK Teacher@discussions.microsoft.com> wrote in message
news:27CC9DD4-BE35-4E4C-B45...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
&...Controlling hyphenated words in columns.
Is there a way to set up linked columns so that words don't hyphenate? I
have tried spacing, reducing font by a half point and adjusting the size of
the column but it seems like a lot of work to set it up, then when printing
sometimes the layout changes again.
Tools, language, hyphenation.
Or if you want the hyphenation turned off for this and all future publications,
tools, options, edit tab.
Mary Sauer MSFT MVP
"misskitty" <firstname.lastname@example.org> wrote in message