How can I use day of year dates in Excel?
I have data in Excel that has one column with the year (eg. 2005) and another
column with day of year (eg. 365 for Dec. 31). I would like to convert this
to a date format that Excel can use for calculations, graphing, etc.
See if this works for you:
A1 = Year
B1 = Day
> I have data in Excel that has one column with the year (eg. 2005) and another
> column with day of year (eg. 365 for Dec. 31). I would like to convert this
> to a date format that Excel can use for calculations, graphing, etc.
Thanks much! This s...Annoying Prompt at Close
Hi all, I have an Excel workbook that was originally
written in Quattro Pro and later converted to Excel.
Every time I close the workbook, even though I have NOT
made any changes, it asks me if I want to save
the "changes". This is very annoying. Can anyone tell me
what I could do to get rid of this prompt?
CC, you may have a formula in the sheet that is calculating every time the
workbook is open, something like =NOW()
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can be...Excel 2002 Problem
all Hi I am working on excel to get an ouput like this
Cloumn A Column B
Like this whenever i enter a new name in column A it has to tell th
whether the nameis appearing for the first time / 2nd / 3rd etc.,
can u pl solve this proble
Message posted from http://www.ExcelForum.com
see your other post
>all Hi I am working on exc...Modify existing custom cell format (Excel 2000)
I have a worksheet that includes a number of custom formats that are
applied throughout to various cells. Is it possible to change an
existing custom format so that all those cells that use it are
automatically changed. For example, one of these formats is of type
0.00 "Deg" and I want to change it so that cells using this format
show values with the degree symbol "�" instead.
Since Excel doesn't seem to have a "find and replace" format feature,
how can I make such a global change without individually selecting
each applicable cell and applying a new format?
...Old Excel doc + PW Protection
I am trying to open an old Excel document (was probably written with Excel 4
or 5) in Excel for OS X, that have password protection on (Excel ask for a
password everytime I open it, and of course I know the Password). I want to
take the PW off, so I click on the Tools menu + Protection... But Unprotect
option is not available, like if the Protection feature was never activated.
Is there a way to disable this using a utiltysoft like BBEdit or something
There is more than one place to protect an Excel workbook. In your case, it
is the file that is pro...Linking many EXCEL tables into a long WORD document
Would anyone have direct experience with linking lots of
Excel tables into complicated Word reports - say 100
tables into a 100 page document?
I tried this years ago shortly after OLE came out, but the
document's links got confused, with Excel occasionally
getting confused about which worksheet tab and range
belonged in which Word table. This was not a case of my
error, nor of corrupted files due to crashes, but was
confirmed as a problem with Excel by a person knowledgable
of its codes and bugs back then.
Needless to say, I stopped aiming at having these live
links in my docum...Charts in Excel
I am sort of new to excel. I use the spread sheet to track network up and
down time. I have two diffrent workbooks, one for lan and one for wan. I keep
years of data in the workbooks, but only want to see 6months on the charts.
How do I set up the chart so all i have to so is add the weeks line and the
chart is generated for 6 months and I dont have to do it manually?
thank you in advance for any help you can offer.
Jon Peltier has information on creating dynamic charts:
> I am sort of new to excel. I use the sp...more KompoZer annoyance
Yesterday I posted a note regarding Vista Home Prem complaining
that KompoZer-0.7.10.exe did not have a valid signature.
It was suggested that KompoZer was polluted and I should download
a fresh copy. ... No problem. ... I downloaded a fresh copy.
new copy KompoZer-0.7.10-win32.zip
A file comparison of the original and the fresh copy shows that
they are identical.
Just to be sure, I erased the old copy
and then tried to use WinZip 8 to extract and re-install.
If you double click ...excel table help
Name Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7
Bill Buffalo Pittsburgh Utica Jacksonville Buffalo Houston Dallas
George Pittsburgh Buffalo Dallas Seattle Indy Carolina Miami
What I want is this in the main spreadsheet. The users from week to
a city. (preferably picking cities from some sort of table) So that
etc. is consistent. THE CATCH is no user can pick the same city
So if you look at user BILL they picked BUFFALO in Week 1 and BUFFALO
aga...Export Excel Chart to .gif or .png file
then I used to select and copy individual charts in an Excel file and paste
them into PhotoDraw to create .gif and .png files. Recently I lost access to
PhotoDraw (a dictated productivity enhancment) and am wondering what current
product MS has to replace this functionality?
If you don't feel like programming, use John Walkenbach's Chart Tools
utility (free from http://j-walk.com) to export your charts.
If you're not afraid of a little VBA, check out the Chart.Export method.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solu...Highly annoying namespace problem
I've the following code, taken from
to select a node from RSS file.
However, I'm always getting a null returning for the SelectSingleNode(),
when trying to load a RSS 1.0 document, (which has a default namespace)
NamespaceUri = "http://purl.org/rss/1.0/";
else if(feed.DocumentElement.LocalName.Equals(&qu...excel page setup
I have a spreadsheet and I am using cells a:k50, but when
I go to see the end of my spreadsheet it tells me I have
used cells a:ak 295. I have 35 sheets like this and is is
making the file bigger than it has to be. I have tried
deleting, clear, page preview setup but nothing seems to
clear and make my page a1: k53. Any suggestions. Thank You
Select the row following the end of your data. Ctrl+Shift+Down Arrow to
select all rows beyond your data and Edit>Delete.
Select the column following the end of your data. Ctrl+Shift+Right Arrow
(US) to select all columns beyond your data...how to import excel chart and table in visio
i have prepared diagrams, and illustrations in microsoft excel(using lines,
i want to import the table in visio and use the superior graphic abilities
please advise on how to do this.
Just copy and paste into visio. Then select the pasted image and ungroup
"S N" <firstname.lastname@example.org> a �crit dans le message de
>i have prepared diagrams, and illustrations in microsoft excel(using lines,
> i want to import the table in visio an...Sharing Excel templates
I have several spreadsheets used for investing and an Auto MPG calculator I
would share with others.
Can they be emailed to Microsoft for review and added to the Office Download
...Excel 2000 STILL hangs on sort
I still cannot understand why I am the only person on this whole planet who
seems to have problems sorting Excel spreadsheets. I simply cannot imagine
what it is about my system that is unique.
As I have repeatedly griped without getting any useful response:
1) I cannot sort any spreadsheet where the data contains a question mark
2) I cannot sort moderate spreadsheets (>2500 rows) where the data
includes the results of a subtraction.
The bypass for the first problem is to remove all question marks (by
searching for '~?'). The bypass for the second problem is to co...number rounding in MS Excel
This may have been answered many times.
In MS EXCEL is there a way that it calculates all numbers to 2 decimal
digit accuracy instead of the 15 digit default?
Thanks in advance for the answer.
You can set your decimal places in your cells as 2 and then check Precision
As Displayed on the Tools / Options / Calculation page. Be careful though,
it means what it says!!
"mahusain" <email@example.com> wrote in message
> This may have been answered many times.
> In MS EXCEL is ther...How do I reactivate "Save On Exit" in Excel 2007?
How do I reactivate "Save On Exit" in Excel 2007? It seems to have been
turned off somehow.
You mean Warn you to save on exit? You running a macro to disable that
Tom Edelbrok wrote:
> How do I reactivate "Save On Exit" in Excel 2007? It seems to have been
> turned off somehow.
No, no macro.
When I make changes to an Excel 2007 spreadsheet and close it, it no longer
asks me to save. It just closes without saving. I want ...Refresh Excel Webpage
I have an Excel spreadsheet comprised of 9 worksheets. I need to be abl
to save as a webpage and allow a number of individuals open the web pag
an keep it open. While open, the page needs to be refreshed frequentl
since the spreadsheet is updated constantly. I have tried adding th
<meta http-equiv="refresh" content="15">
but each time the the spreadsheet updated and saved as a webpage th
file is over written thus no refresh code.
I have tried creating a webpage with a frame but when the pag
refreshes the frame does not, though F5 will refresh the pag...Excell 2003
I have a spreadsheet that ends at Q24..is there anyway that all the cells after Q24 are not shown. I think what I am trying to accomplish is saving option but I am not sure
Thanks for any help
in the Name box (at the left end of the formula bar). Hit enter to
select the rows. Choose Format/Rows/Hide.
in the Name box. Hit Enter. Choose Format/Columns/Hide
In article <797C5100-4F9B-40E7-B056-506DB6203E46@microsoft.com>,
"Missy" <firstname.lastname@example.org> wrote:
> I have a spreadsheet that ends at Q24..is t...Event ID: 2012 / 2013 SMTPSVC [ANNOYING ANNOYING ANNOYING]
I get these errors every hour on the hour for the past week.
My logs look nasty with all these reds and yellows...me no likey, MS plz
fix. thank you.
Ode to Event ID: 2012 and 2013
Stop errors are Red
Warning are yellow
If I get more of these errors
my server will not say HELO
Event Type: Warning
Event Source: smtpsvc
Event Category: None
Event ID: 2012
Time: 6:57:22 AM
SMTP could not connect to the DNS server '10.0.0.25'. The protocol used was
'UDP'. It may be down or inaccessible.
For more information, see Help...Importing number format problem in Excel
I am trying to import numbers from a table in Access that
is stored as a number format into Excel and Excel does
not recognize the numbers as numbers. I have to manually
convert the numbers format via the Excel error checking
I have this problem when trying to paste any type of
number format in Excel.
How can I change the default settings in Excel to
recognize number formats and automatically paste them in
I am using Excel XP in case it matters.
Debra Dalgleish has posted a couple of techniques for fixing this after the
http://groups.go...Why is Excel being opened in Outlook?
I emailed an Excel file to a colleague. It was sent as an attachment in
Thunderbird. The recipient - who uses Outlook - saved the spreadsheet to disk.
Now if she tries to launch the file (either from Explorer or from within Excel
itself), it actually opens up inside Outlook and starts to create an email
message. This only occurs if Outlook is already active. It also only occurs with
some of the spreadsheets that I sent her.
You sure your colleague isn't just seeing the "envelop".
File|send to|and see if "mail recipient" is depressed.
> ...Excel backup file
I have an excel file that always created a backup copy (.xlk) when it’s save.
This allows the label program to use the backup file without interfere with
the user updating the actual file. In Excel 97 it works perfect because when
the label program using the backup file and someone try to save the xls, it
will display “backup file will not be save” but it allows the xls to be
saved. But Excel 2000 or xp it does not allow xls to be saved if the backup
file is in use. Any suggestions how I can get around this problem?
Instead of using the backup, how about just saving the workbook wit...Excel 2000 #9
Is there a way to change the date format in footers and headers.?.these two
items do not seem to pick up the formatting specified for the individual
Excel in any version uses the Short Date format from Windows Regional settings
You can make some minor changes in Regional settings but not too much.
How about a macro to add the date in any format you choose?
.PageSetup.CenterFooter = Format(Date, "dddd, mmmm-dd-yyyy")
Gord Dibben MS Excel MVP
On Tue, 5 Feb 2008...Excel "Micorosft Query" from Access (Too Many Parameters)
• In Access I can enter a dynamic parameter that is read into a query
(sql statement) - - the parameter is usually in a form
• I then utilize the Data tab in Excel – from other sources “Microsoft Query”
• If I have a hard coded parameter it pulls data from Access just fine, but
if I have a dynamic parameter it refuses and says “too many
• My question is – is there a work around?