How to convert day of a year
I have sheet where date is expressed as day of a year.
I know that converting from day-month-year into day of a year is quite
easy, but I don't know how to do this in other direction.
I have tried to write multiple if confitions, but it's generating many
Is there any convenient way of doing it (maybe macro ?)
> I have sheet where date is expressed as day of a year.
> I know that converting from day-month-year into day of
> a year is quite easy, but I don't know how to do this in
> other direction.
I would think you are looking for this...
I have a question..I have a client and they want us to test things on a
machine beofre he moves it out into the lanes...
is there a way that I can install on a machine thats not going to be a lane
for testing purposes then be able to transfer it to a lane with no problems?
I think you just need to get the demo version first for testing
"Angelique" <Angelique@discussions.microsoft.com> wrote in message
>I have a question..I have a client and they want us to test things on a
> machine beofre he moves it out ...Also Can't Install Latest Update
Operating System: Mac OS X 10.5 (Leopard)
I'm using a registered version of Office 2008, version shows 12.0.0. Have been trying to install the latest patch 12.1.0 with no success. It sits for ages on the 'examining additional volumes' stage (there are no additional volumes) and then eventually puts the red exclamation mark on my disk with the note, "..a version of the software required is not on this computer.."
I have tried the Autoupdater and the standalone download. Have tried with nothing else running (shift key held whilst logging-in)...How do I split a large document in to separate files for review
I am creating a large document (>150 pages) with multiple chapters and
sections. I need to be able to send only a chapter at a time for review
without losing the auto numbering of tables, graphs, section titles, page
numbers, etc. In the previous word version I used a master document with
each chapter being a separate file. Does anyone have a suggestion for word
2007 in Windows 7?
> I am creating a large document (>150 pages) with multiple chapters and
> sections. I need to be able to send only a chapter at a time for review
> w...Invoice Design Cannot Save My Invoice Designs
I know I have seen an answewr to this issue, but for the life of me, I
cannot find it.
When I design an invoice, I do not seem able to recall and load the one I
designed and saved! - It does not appear in the list of available invoices -
I seem to remember the solution was a fix, or small change in the
Any advice is welcomed and appreciated.
Thanks in advance.
...Recovering EXCEL files
There are times when Excel will crash for some reason and when I reopen
Excel, the files show as "recovered". Where are the recovered files stored?
We found where the autosave was saved for this computer. No assistance
needed at this time.
"Barb Reinhardt" wrote:
> There are times when Excel will crash for some reason and when I reopen
> Excel, the files show as "recovered". Where are the recovered files stored?
> Barb Reinhardt
...importing multiple text files into excel???
I am experiencing a big problem. As a part of my analysis for PhD I have to
analyze more then 1000 files. The data that I have is in text files. To be
more precise, I have 5 different data sets, from different meteo centres,
each centre has a data set of 365 files for each day during the year. The
format of text files is something as following:
Camborne Met. Office
WINDS rev 4.1
50.20 -5.30 88
02 01 01 00 00 23 0
29 3 35
07:09 (3.0) 07:09 (3.0) 06:08 (3.0)
284 284 65 65 400 400 23 23
12.5 12.5 1 1500 1500 35 35 400 400
43 90.0 43 74.5 313 74.5
HT SPD DIR Radials...
0.101 9.8 113 0.0 ...Failed to install: Business Data Lookup Snap-in for CRM 3.0
I went through the Installation wizard without errors or warnings.
The Business Data Lookup Snap-in for Microsoft CRM toolbar does not appear
in Word or Excel. I have tried to do as was instructed in readme-file, but it
I should click View -> Toolbars -> Business Data Lookup Snap-in for
Microsoft CRM, but the toolbar is the same than before (no Business Data
...How to tell what Updates have been Installed?
I just tried the Microsoft AutoUpdate and it says there are no updates
for your software at this time. I then clicked on the "View Installed
Update" button and shows no history. Just blank page.
My Entourage version is 12.0.1 and I think this is the current version.
Should the 12.0.0 to 12.0.1 update be displayed on the installed updates
How can this update be added to the blank installed updates page?
There were some issues with 12.0.1, obviously--it doesn't show on my
I don't know for sure, but I would expect that 12.1 will be a combo
updater...Money 2005 file conversion issue from 2004
Bought the software and loaded it to my laptop. Did the
file conversion (running 2004) and it opened the
file......once the first update occurred the application
goes dead - screen freeze. Now when I open 2005 the
screen immediately freezes.........I also noticed in my
directory that my original file which was about 10mg is
When I create a new file in 2005 it works fine and
everything is good. So it appears the Money 2005 is have
a problem with my existing 2004 money file.........
Anyone else having this problem????????
I have had problems with the file updating...Value Pak Installer
Does anyone know how I would access Value Pak installer for Mac Office X?
Can it be downloaded from the Microsoft web site, and if so, where?
On 3/6/04 6:59 am, in article email@example.com,
"Brian" <firstname.lastname@example.org> wrote:
> Does anyone know how I would access Value Pak installer for Mac Office X?
> Can it be downloaded from the Microsoft web site, and if so, where?
For Office vX, the value pack is on the installation CD.
For Office 2004, there is no separate value pack.
Barry Wainwrigh...Installation #4
I am not sure that I am in the right place but I am
trying to install Disc2 of Office 2000 Pro on Windows Xp.
I keep getting a Not Responding prompt after I key in the
Product Key Code. It identifies a file or something that
is ---- SzAppName: msiexec.exe
I really could use some help getting this resolved. I was
able to install Disc1 with Word and such on it. I would
like to install Disc2 that has Publisher and Small
Please advise ASAP.
Hi Paul (email@example.com),
in the Microsoft� newsgroups
|| I am not sure that I am in the right place bu...Do I need to install Office 2003 updates for Window 7?
I have a new computer with Window 7 operating system. I used my original disk
and product code to install Office 2003 and it seemed to go well. Now I am
wonering if I need to go back and install Office 2003 updates. I am
primarily worried about Office 2003 security but thinking maybe Windows 7
takes care of that. If Windows 7 does not, which ones need to be used to
update and how do I get access to them?
"Gracious" <Gracious@discussions.microsoft.com> wrote in message
> I have a new computer with ...Installer for my access application
I searching for installer for my program.
It must support creating link like "path to msaccess.exe" "path to
myprog.mde" /wrkgrp "path to users.mde"
Is anybody know best solution for this???
Thank you in advance.
With best regards, Alek Luchnikov. E-mail:
Look at Inno setup. It's free.
"Alek Luchnikov" <alekluch---FORSPAMERSfirstname.lastname@example.org> wrote in message
> Hello, All!
> I searching f...File comparison
I have 2 separate Excel files. Each file contains about 100 symbols. I would
like to run a quick COMPARISON
the content of these 2 files in order to identify those symbols words that
appear in BOTH files.
Finally I would like to write the results to either of the original files or
maybe to a third Excel spreadsheet.
* Is there an excel function or program that can achieve this objective ?
Deeply appreciate any assistance with this problem ?
P.S. Would it be better to first bring the content of both files into
separate columns of the same spreadsheet ?
h...How do I change which software views my jpg files when I download.
Please help, it keeps going to the wrong software!
On Tue, 4 Jan 2005 18:21:02 -0800, pamieg
>Please help, it keeps going to the wrong software!
This has nothing to do with Outlook...
It would help if you mentioned your operating system, but...
In Win 2000:
Open Windows Explorer.
Then Tools | Folder Options | File Types.
Once there, you can associate your *.jpg files with any
software you wish.
If that does not work for your OS, I'd suggest looking in
the help file for "File Associations" then "Associate a ...Frequent file corruption in the documents and setting area
Since a month or so, I have frequent messages 'corrupted file, run chkdsk'
The files concerned are ALWAYS in the 'documents and setting' directory,
often temp files, or
Norton 360 files.
I am quite positive that the disk itself is sane (only 1 raw sector is
reallocated in SMART).
Any idea from what area could the problem come ? I do have units up to K (2
physical units), and only this
directory ever get corrupted on G (system XP pro)
"Jean-Paulo" <email@example.com> responded in News item
...Converting and adding lbm & ozm
I am trying to build a spreadsheet to total five separate fish weighe
in pounds and ounces. I need a column for the name of the fisherman
1st fish, 2nd fish, 3rd fish, 4th fish, 5th fish (each in pounds an
ounces), and a total column in pounds and ounces.
I would also like to designate a point value by the most weight t
least, (160pts 1st, 150pts 2nd ... 10 pts 16th place). I also need
column to denote a 2 oz penalty for each dead fish, that would then b
subtracted from the total. I also will need to be able to total betwee
two sheets, so I can show totals for a two day tournament where the 1...Fresh install, crystal issue.
During an install on an Enterprise server 03 SP1, I have run into DEP or Data
Encription Protection. This stops each of the crystal services upon install
and therefor after the install we recieved the infamous crystal license
error. We checked and the APS service is not started and will not start no
matter what we try. Also there is three tables missing from the Crystal
database: APS_IdNumbers2, APS_InfoObjects2 and APS_VersionInfo.
I am guessing that the missing tables is the reason the APS wont start, If I
copied these three tables from another database would this work for getting
...is there any warning signal when pst file grow too big
hi, is there any way to noticfy when the personal folder had grow too large??
There are policy settings for this for Outlook 2003.
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1
"sailfish" <firstname.lastname@example.org> wrote in message
> hi, is there any way to noticfy when the personal folder had grow too
...Printing Without Name On E-mail
When I print an e-mail I get my name printed at the top with thick line
underneath. I checked in MEMO STYLES under PRINT SETUP and user name is not
set to print. I turned off MS WORD as my editor in case that's where it's
coming from but still prints my name at top heading. It does not show when I
view the email in the INBOX view pane.
Thanks for any help.
...Can I check out multiple files at one time in SharePoint?
Thanks for the help.
Not with the standard UI. Perhaps with some custom coding you could make it
> Thanks for the help.
You can try SPBulkActions which allows, among other things, bulk check-
On Nov 30, 3:49=A0pm, hvharr <hvh...@discussions.microsoft.com> wrote:
> Thanks for the help.
On the other hand, you can have more than one item checked out to you at any
Daniel A. Galant
Imagine what we could be... if we could just imagine.
&quo...Installing XP over Linux
I am trying to install Windows XP on a Dell laptop that currently has Linux
Ubuntu installed. After booting up with the Windows CD in the drive, it
loads various Windows files, but eventually stops on a blue screen message
advising me to run CHKDSK, but won't respond after that. I suspect that
Windows is seeing the Linux partitions as disk corruption, but how can I get
"Kev" <email@example.com> wrote in message
>I am trying to install Windows XP on a Dell laptop that currently has Linux
Of all the accouns I tried to convert, two refuse to convert to newer
currency in spite of all my attempts. Any suggestions will be helpful.
What kind of error do you see?
Glyn Simpson, Microsoft MVP - Money
Check http://support.microsoft.com/default.aspx?scid=fh;EN-GB;mny or
http://money.mvps.org/faq for UK tips and fixes for MS Money. To send
Microsoft your product wishes see http://money.mvps.org/wishes.aspx
I do not respond to any unsolicited email regarding Money
"M F Adajania" <firstname.lastname@example.org> wrote in message
news:OHZ7yZ...OL2003 "PST File Not Closed Properly"
Even when it really was, I get this every time I open Outlook 2003, and it
insists on checking for errors.
Anyone else get this?