Excel, how do I change the column headings from letters to number
I have a spreadsheet that has numbered columns as opposed to the standard
letters. How can I change this back to letters?
Go to the Tools menu, choose Options, then the General tab.
There, uncheck the R1C1 reference style setting.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"lazybee" <email@example.com> wrote in message
>I have a spreadsheet that has numbered columns as opposed to the
> letters. How can I change this ...Exchange 2000 DST Changes
How is one supposed to address the DST changes for Exchange 2000 if
they do not have extended support to get the patch? Will Microsoft be
providing a workaround like they did for Windows 2000?
I'm referencing the following article:
It states :
What to do before you run the Exchange tool
Install DST updates
Before you run the Exchange tool, make sure that client and server
computers are updated correctly with the operating system and
application DST updates. These updates must be installed in the
1. Install the Windows DST upda...Changing Item #'s
Is it possible to change the item #'s after the item has already been entered?
No there isn't in the "base" product, but MBS does have a tool that you can
use called Item Modifier - this will allow you to change an Item number from
one value to another.
You can email this address below and they can answer any questions you have
about the tool and can tell you what the cost of it is.
Hope that helps you out,
> Is it possible to change the item #'s after the item has already been entered?
...Trying to create an Update query based on HR data to find upline V
Hi All, looking for some advice. I have an HR table that contains employee
information but does not contain management chain info. Basically i am trying
to determine who the employees upline VP is. The fields i have to work with
are [Employee Name], [Manager Name] and [Job Title]. I figure the logic would
be to check the employees' manager and if the manager is a VP (based on job
title), return the manager's name to a field called [VP]. If the manager is
not a VP then check that manager's manager, so on and so forth until a VP is
Any ideas would be much appr...loan amortisatio chart not updating
I use MS Monet 2007 premium. I have created a loan amortisation account
which breaks up my monthly instslment into pricipal and interest. The loan
commencd from 7 October 2005 and is for a period of 5 years. The problem is
that the loan account does ot show any loan instalments beyond 7 October
2006 (exactly 1 year after the commencement). Why is this happening. Why
is the account not updating with instalments which have been debited to my
account after 7 October 2007.
Were you depending on downloaded transaction data for this account? Did the
download link br...Insert,Update Data in sage (MS Access Linked tables) using Vb.net form
I am developing application using vb.net which requires integration with SAGE
LINE 50 (Accounting software ) V11... The data which SAGE is using is MC
ACCESS 2003 database... with linked tables in it... Now I Have developed the
Sage connection using ODBC which works fine when reading the record but
cannot Add or Update record into the Linked tables.... When i debug the
program the error is at the line where it has...
Can anybody Help ?????
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/acce...Excel 2000 vs. Excel 2002
I am having troubles with a workbook that I created that is havin
I created it in 2002, and it opens fine in Excel 2002 for other people
However, when I send it to someone who has Excel 2000, it takes over a
hour to open.
Now I also made a very similar report that works just fine whe
trasferred to excel 2000.
Here are a couple of stats on the workbook that is having problems:
500+ externel links
200+ simple calculations (a1+b1; a1/b1;etc..)
1 Worksheet in the book.
2 columns with conditional formatting
Message posted from http://ww...Time update as a limited user not working
I added time update permisssion to my limited user acct. but it does
When I try, the time synchonization is greyed out.
How can I get it to work.
On Apr 4, 12:33=A0pm, Mint <chocolatemint77...@yahoo.com> wrote:
> I added time update permisssion to my limited user acct. but it does
> not work.
> When I try, the time synchonization is greyed out.
> How can I get it to work.
Is this Windows MCE SP2?
What method did you use to add time update permission to your limited
Does your unlimited user accou...Two instances of outlook 2002 on the same desktop.
I have two sets of accounts that I manage with my
outlook. I would like to be able to run two copies of
outlook, each working on thier own set of accounts. Could
any one help me understand how we can do this , please?
I would appreciate any help.
...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...Excel Running Wild After Update
I ran the Office update via Auto Update. Word and Powerpoint seem fine
but Excel attemtps to open every compatible file (and a few that
aren't) when I start it up. After it overdoses on files it fails and
closes. Any ideas on what to do other than reverting to an older
Look in Applications:Microsoft Office 2004:Office:Startup:Excel: . Are there
a bunch of random files in there? I think Excel would try to open anything
in there on launch.
On 3/23/06 9:04 AM, "Jeff Fread" wrote:
> I ran the Office update via Auto Update. Word and Powe...Outlook 2002 (XP) Holidays for 2006
How do you get the holidays added to your outlook calender for 2006? When I
do the Holiday Add-in under options it says it can only add holidays for
years 2001 - 2005. Is there anyway to add the 2006 holidays?
Thanks in advance.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, Lisa Beach asked:
| How do you get the holidays added to your outlook calender for 2006?
| When I d...Changing named range reference depending on a cell's content
Where to start?!
I've got the following formula pulling data in from a secon
spreadsheet within the same workbook:
We have 8 different locations ("MICH" being one of them) that we nee
to be able to access. I can write a nested IF formula that looks a
cell I7 (that contains a list of all 8 locations) and, depending o
I7's content, brings back the desired values.
I was hoping someone in the forum could help me write a simpler formul
that would not have 7 IF statements embedded in it.
Any help w...insert text to different pages and update
Is there a way to insert a text cell from one page put into another page
and when the first page cell is updated the second page cell will also
be updated. Using the = sign just displays the formula, not the text.
fwburkey's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30314
View this thread: http://www.excelforum.com/showthread.php?threadid=505331
Not clear what you are doing wrong. the formula should look lik
=Sheet1!A1 Make sure there is noth...Stop changing of languages in Word 2003 when typing letter.
While typing a letter in Word 2003 it changed from English to what looked
like Arabic language. I have rebooted 3 times and started over and still
the same occurs. I even copied what I had in English to an email in Yahoo
and sent it to myself and rebooted. Came back to that same email and copied
it to a new email that I started to myself, and when I started typing it
would only type in what looked like Arabic language.
This happened to me once a couple of weeks ago, but never occurred again
What do I do?
In the Language dialog box, turn off the option to autom...how can I draw a box and whisker plot in excel 2002?
I have some data, and have worked out the minimum value, the 1st and 3rd
quartiles, the median and the maximum, but need to find out how to put this
together in a box and whisker plot
Bernard V Liengme
remove caps from email
"andywilson" <firstname.lastname@example.org> wrote in message
>I have some data, and have worked out the minimum value, the 1st and 3rd
> quartiles, the median and the maximum, but ...Strange behaviour: show/hide formatting symbols reveals old change
In Word 2007, I'm getting some strange behaviour in a document that was
authored by someone else. Track Changes is switched off, all changes have
been accepted, and everything looks as it should in whichever view I happen
to choose (Print Layout, Draft, whatever). But when I click to show
formatting symbols (in whatever view) a whole lot of old changes - deletions
AND insertions, ostensibly all accepted, and from before the document got to
me - appear in the document, making it quite tricky to work with. These old
changes are impervious to anything I try to do with them
E...Color change in cell when > 49.99
I need a cell to change color if the value inside the cell reaches 50 or
higher.either text or cell shade. just so it catches the users attention.
im running excel 2000. and i have this currently in the cell that i want to
aplly this to:
have you tried conditional formating?
>I need a cell to change color if the value inside the
cell reaches 50 or
>higher.either text or cell shade. just so it catches the
>im running excel 2000. and i ...stop default website of users pointing to the companyweb
I just migrated a W2K3 to SBS2008.
How can I dissable the pointing all default websites of all users to the
http://companyweb? everyone wants to have his own default website.
Group Policy Management
Windows SBS User Policy
Internet Explorer Maintenance
Home Page URL - remove http://companyweb
Customise Home Page URL - remove tick
Russell Grover - SBITS.Biz [SBS-MVP]
MCP, MCPS, MCNPS, SBSC
Small Business Server/Computer Support - www.SBITS.Biz
Question or...February updates on EPM (WSS+PServer+MSProject)
February updates Links are available on http://epm2007.wordpress.com
You can comment and poll to give feed back on post installation.
If you have sufficient permissions:
File -> Open ... -> Retrieve the list of all projects ...
Right click on project name and select Rename.
Project Center -> mark project in any column except Idicator and Project
Name. Click on Edit Project Properties. Change name and click on Save
Am 01.03.2010 08:58, schrieb Xavier HOVASSE...embedded pictures in emails
I often receive emails with pictures embedded (not attachments) . the
pictures are meant to have moving objects such as cars, people etc when you
open the email, however when I open the email in Outlook 07 (vista), my
pictures are still. Could this be my settings ??????
Mars <email@example.com> wrote:
> I often receive emails with pictures embedded (not attachments) . the
> pictures are meant to have moving objects such as cars, people etc
> when you open the email, however when I open the email in Outlook 07
> (vista), my pictures are still. Co...Date/Time Show When Changes Made
When changes are made in a table or form, I want the date and time to appear
showing me when changes were made in any of the fields.
How can it work?
It's not possible if you're working directly with tables.
Using foms, you have to put code into the form's BeforeUpdate event to
update the row's LastChanged field (which, of course, you have to add to the
You might find what Allen Browne has at
http://www.allenbrowne.com/AppAudit.html to be useful.
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"Beame...OWA and password change
I have OWA in the DMZ but the mail server is behind the DMZ. I have no
problems accessing OWA but I do have a problem see the users on my DC. The
real issue is that I am trying to have users change their own password
within OWA and need to know what ports I need to have open without any
security breach. I need to know what is safe to open and what's not safe to
have you seen this articel s?
F...formatting of charts changes when copying from excel 2000 to 200.
When I copy a chart from Excel 2000 and paste it into Excel 2003, some of the
formatting is lost. In particular, scale and axis formatting. Is this a
programming issue or can it be corrected easily.
First one would answer why would you copy charts from 2000 to 2003, why not
make them in 2003?
Second and more important - how are you copying them - there are maybe 20
possible methods of copying a chart from one program to another. Please tell
us exactly which steps you use to do the copying. Also, exactly what
formatting are you loosing, what do you get instead?
When ...updates 05-29-10
I keep getting configuering updates when I turn on anff my computer.Also cant
search for updates and there is no record of any updates being downloaded
> I keep getting configuering updates when I turn on anff my
> computer.Also cant search for updates and there is no record of any
> updates being downloaded
When was the last time you freshly installed Windows ME?
How To Ask Questions The Smart Way