Re-arranging table using pivot-table?
I have a worksheet with data organized somewhat like this:
New York New York
New York Albany
California Los Angeles
California San Diego
I need to convert this to a list of states and each city in the columns to
the right of their corresponding state. Something like this:
New York New York Albany
Florida Miami Orlando Tampa
California Los Angeles San Diego
Any help is greatly appreci...Text & Date same cell
Sheet1 has date in A1 (1/1/2005) formated as Date.
'=IF(Sheet1!A1>1,"MyDate" & Sheet1!A1) <- formated as Date
'="MyDate"&IF(Sheet1!A1>1,Sheet1!A1) <-formated as Date
Both display -> MyDate38353
How can i make it display -> MyDate1/1/2005
Desert Piranha's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2893
View this thread: http://www.excelforum.com/showthread.php?threadid=49296
=&q...Changing password #2
If I change a domain user's password, will that user's
Exchange Server 2003 mailbox's pssword be changed too?
I mean, does Active Directory share the same password
with Exchange Server 2003?
Exchange never had passwords separate from domain, not even in Exchange
4-5.5 era. So you would change just one password, which belongs to AD
> If I change a domain user's password, will that user's
> Exchange Server 2003 mailbox's pssword be changed too?
> I mean, does Active Directory share the same password
> w...How to paste text into a comment box using toolbar commands
I have a range of cells containing text on one worksheet.
I want to paste this text into a Comment Box in a NEW worksheet.
Thanks for your help .....
"Halifax" <Halifax@discussions.microsoft.com> wrote in message
>I have a range of cells containing text on one worksheet.
> I want to paste this text into a Comment Box in a NEW worksheet.
> Thanks for your help .....
I don't see the problem. Copy the text, and in the new worksheet paste into
Asking a question?
Please tell us the version...No blank lines in text files #2
When opening a comma delimitted file, I don't get blank lines anymore. In
Excel 2000, if a line in the text file was empty I would get an empty row in
the new spreadsheet. Now all non-blank rows are jambed together in one
column! How do I get Excell2003 to opoen Comma Delimitted files properly
(including empty lines?)
Oops, managed to send the same question twice! How can one delete a subject?
"Charlie Gotwald" wrote:
> When opening a comma delimitted file, I don't get blank lines anymore. In
> Excel 2000, if a line in the text file was empty I would get an empt...Weight conversion
Can anyone tell me if possible wether there is a way to get excel to
understand stones and pounds (base unit 14) i.e. 10.12 needs to be
10.twelve not 10.onetwo
If you want to convert to stones & decimals, then =INT(A1)+MOD(A1,1)*100/14,
or if you want pounds, use =14*INT(A1)+100*MOD(A1,1)
The above assumes that you'll enter 10st 7lb as 10.07, not as 10.7.
If you're going to put in 10.7, then you'll need
=14*LEFT(A1,FIND(".",A1)-1)+RIGHT(A1,LEN(A1)-FIND(".",A1)) for pounds, or
=LEFT(A1,FIND(".",A1)-1)+RIGHT(A1,LEN(A1)-FIND(".&q...Re-install Outlook 2002
I am trying to re-install Outlook 2002 for my palm pilot
after a crash. The installation will run until I get the
message - "another version is already installed and must
be uninstalled". The previous version was corrupt and I
was unable to uninstall it. Now when I go into the control
panel to add/remove the uninstall is no longer in the
...Re-Enable CRM User
I am trying to enable a disabled CRM user and I received the following error
message. Any thoughts or suggestions would be greatly appreciated.
String UserId) +0
Microsoft.Crm.Application.Platform.SystemUser.Activate(String id) +38
sender, DataEventArgs e) +127
eventId, FormState state, User user, String objectId,...RE:Excel will not open from a web link
When opening a link on a web page that has an Excel
Spreadsheet embedded in it, the spreadsheet will not open
up Excel but opens within another browser as an Excel
file. Programming on webpage is correct, opens up on
other machines just fine.
...how do I change the dektop icon for windows word
Not a Word issue. It's a function of Windows.
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"Bill" <Bill@discussions.microsoft.com> wrote in message
Right-click on icon > Properties > Change Icon
"Bill" <Bill@discussions.microsoft.com> wrote in message
news:FCD9D7DE-1AFA-471A-9327-ABD18F918A67@micros...How do i change my file from a 2003 office doument to a 2000 docu.
i have done this before with a word document but i dont seem to be able to
figure out how to do it with a publisher document.... can anybody help??
File, save as, files of type, expand the menu to Publisher 2000.
Mary Sauer MS MVP
"me" <firstname.lastname@example.org> wrote in message
>i have done this before with a word document but i dont seem to be able to
> figure out how to do it with a publisher document.... can anybody he...Thanks Ken Wright but one more question RE saving data from circular references
Thanks heaps for that macro Ken Wright .
I have run it and it works.
However it loops forever. Can I set it up so that it could save dat
from a certain number of iterations?
Thanks again Michae
Message posted from http://www.ExcelForum.com
If you stayed within your thread and did not change the subject
Ken would see your reply as a reply to his reply and would see
it a lot faster than when you start a new thread. Ken would
probably see your post highlighted in RED. Also someone other
than Ken might have been able to help you. (not me I avoid
anything that hints of circul...Stange behavior between MFC and COM in VC6
I have discovered an unusual bug which is easily reproducible. I am
wondering if anyone has ever noticed this:
Create an MFC application with a single document interface.
In stdafx.h add near the top:
#define _WIN32_WINNT 0x0400
In the CDocument constructor add:
Build the app. Now click File Open and navigate to the desktop shortcut at
the top of the tree view. From here you should see your My Documents folder
listed (unless you have removed it from your desktop, in which case you
can't test this senario).
If you now double click the My D...Re: exmerge error
I am getting the following error when trying to use exmerg
can anyone please help
Microsoft Exchange Mailbox Merge Program, v4.00.02
Start Logging:February 27, 2004 20:04:3
[20:04:31] Logging Level: Non
[20:04:31] Reading settings from file 'C:\Program Files\Exchsrvr\BIN\EXMERGE.INI'
[20:04:32] Error 8007203a opening an LDAP connection. ('LDAP://EXCHANGE/rootDSE') (CADRoutines::GetNamingContextData
[20:04:32] Accessing Domain Controller 'PROFI...multiple colors on area chart
I've designed a chart with dates (months) on the X axis and numbers (percent)
on the Y axis. Currently, I am using the "Area" chart type which colors the
entire area below the graph line as one solid color.
I wish to have the color change from one color to another at certain points
on the X axis. An example of something similar is found at the bottom of the
any help would be greatly appreciated!!
Plot two series in a stacked area chart, one that has the value when the
chart shows red (and zero otherwise)...Unable to change Assistant in Word 2003
HI - I'm running MS Word 2003 on a Vista Home Premium machine, which came
pre-installed with a copy of Office 2007.
When attempting to change the assistant, I receive the error "There is not
enough memory available to complete this operation."
My system usually has about 40% of its 2 GB RAM free.
...changing paper size #2
I need to change an existing flier created in publisher from letter to legal
size. When I try changing the paper size (under printer set up and page set
up or change template size) the flier is spread out between two pages. I can
only see the two pages in print preview, when I'm working on it I can only
see one page. Any suggestions or ideas? Thanks
When you are finished creating your flyer, File, print, reset your page
preferences on this print screen. There is a print preview on this screen, the
preview should be correct with no tiling.
Mary Sauer ...Save or Update Changes
When I make changes to the data on my form which is based on a query, those
changes don't appear on my reports until I have advanced to the next record.
How could I apply those changes without advancing to the next record?
mattc (at) saunatec [dot] com
Message posted via AccessMonster.com
You need to requery the recordsource, which could be done many different
ways. You could add a command button to your form, or use the AfterUpdate of
a control, or the LostFocus event of...Ron Bovey re: "Trim Selection" in ExcelUtilities
Cells in my Excel spreadsheet appear to be empty. However, when I use
Edit/Go To/Special/Blanks, I get "No cells were found".
In the past, Ron Bovey suggested going to the WWW.APPROS.COM website,
download ExcelUtilities and then use the "Trim Selection" utility to
remove the characters that are making the cells not empty.
Since then, I've gone to the WWW.APPROS.COM website and downloaded the
ASAP Utilities. However, I can seem to find the "Trim Selection" nor
any utility that will do the same thing.
Try going to Rob (not Ron) Bovey's site:
...How do I get invisible lines & borders to re-appear?
In Publisher 2003, table grid lines, text box borders and autoshape borders
have become invisible on-screen, although they do print out. Any ideas on how
to remedy this?
Recently installed Adobe PDF Maker which seems to have precipitated this,
although it could be entirely co-incidental.
Try updating your video drivers.
MVP Microsoft [Publisher]
"Ackerman & Co" <Ackerman & Co@discussions.microsoft.com> wrote in message
> In Publisher 2003, table grid lines, text box borders and auto...changing axis values to custom text
I use office XP
I want to customize the axes of my graphs so instead of numbers (1 2 3 4), it has text of my choosing (poor, average, good, very good). How can I do this?
I hope I'm not entering a redundant post. I looked all over Excel help and have also been unable to find on the website. If I am repeating, any guidance of how I could avoid repetition in the future would be appreciated.
Jon Peltier has instructions for an arbitrary axis scale:
> I use office XP
> I w...How do I Loop and Change Button Color???
How do I loop through a column and change different button's colors
based on corresponding cells values??
This one liner should get you started.
ActiveSheet.Shapes("Rectangle 9") _
.Fill.ForeColor.SchemeColor = 12
Microsoft MVP Excel
"Zach" <email@example.com> wrote in message
> How do I loop through a column and change different button's colors
> based on correspo...change default font size for all fields in outlook 2003
I want to change the default font size for all fields in outlook.
I can inly fin a way to change one view at a time.
...Reports not updating with changes in query
I created a tabular report from a crosstab query and I have since
deleted certain rows, added a column and changed some things but the
report has not changed at all. I don't quite understand why.
1. All your changes didn't make a difference to the report.
2. The report isn't based on the table where you made the changes.
2.1 Check the report's record source to find the exact query.
2.2 Open up that query and make sure it's based on the table that you think
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager ...re re re ????