Date display in Excel
Format column of cells as Date, display as mm/dd/yy. Date
entered into cell, shows up correctly in the text entry
field at the top of the screen, but the data on the
worksheet displays as "33747", or similar number. Only
happening on one workbook.
Try tools|options|View tab|uncheck Formulas.
> Format column of cells as Date, display as mm/dd/yy. Date
> entered into cell, shows up correctly in the text entry
> field at the top of the screen, but the data on the
> worksheet displays as "33747", or similar number. Only
> happening on one...Displaying Scenarios
I have set up a number of scenarios on a worksheet as they
relate to different versions of my budget. Rather than
having to go in everytime and display each one
individuall, I would like to enter a parameter in one cell
that will automatically display the right scenarios.
Hopefully, using a conditional statement of some kind.
Any help would be greatly appreciated.
Jet Moulding Compounds Inc.
Ajax, Ontario, Canada
How about a worksheet_change event?
I created a couple of custom views and then rightclicked on the worksheet tab
that held the important cell. ...Printing In Color
Operating System: Mac OS X 10.6 (Snow Leopard)
I am trying to print a document in word that is color but it is only coming out in black and white. How can I change the color settings on my printer?
Word has no setting to print in color v. B/W -- that's a function of your
printer & its driver software. The settings are available in the Print
dialog in the Copies & Pages List, but exactly where the setting is located
depends to a great extent on what printer you have. Some printers also have
physical controls on the printer, itself, but that isn't common.
...Can the data in a chart table be right justified?
Ecxel 2003 and previous versions of the product center the data in the data
columns. Can the data in the columns of a chart table be right justified?
In article <DABF738B-6C0D-458B-B082-FA9BD8F126A7@microsoft.com>, =?Utf-
8?B?c2FtIGVhZ2xl?= <sam email@example.com> says...
> Ecxel 2003 and previous versions of the product center the data in the data
> columns. Can the data in the columns of a chart table be right justified?
Have you tried to format the table? If yes, and you haven't been
successful it is probably because XL allows very limited cust...Data migration - Adventure Works
I have a company where the adventure works db has been used and had a
lot of data populated into the system. We have now purchased MSCRM and
have obtained the company reg keys.
What is the easiest way to get the data from the 1 system to the next?
We will be establishing a new AD domain and users for the new
Data Migration Framework?
Microsoft CRM MVP
"funboy...set print area #2
Where is the "set print area" button in Excel 2002 that was in Excel '97?
> Where is the "set print area" button in Excel 2002 that was in Excel '97?
Are you sure it was "standard"? Only way I could get in was to right-click
the toolbar|Customise and drag it to the toolbar from Commands|File
...is there a way to program my Excel file to do a loop?
If I want B10 to B17 all follow the change of the same number(copy cell),
let's say I put it in A1,
and C10 follows the change of A2(copy cell), and C11 follows the change of
A3(copy cell), and C12 follows the change of A4(copy cell),
then I have 4 variables in my calculations: A1, A2, A3, A4.
I want to loop each of the variables in a different set,
then I hope the whole worksheet will be able to refresh following the change
of A1, A2, A3, A4,
and then I want to find the very set of A1, A2, A3, A4 that gives the
smallest value of D10,
how do I program the whole procedure...Label a chart of counts with other percentage data
Here's the data:
Group 2005 2006 2007 LTM Data
A 19.4% 22.8% 21.2% 19.9% Profitability
A 6 7 7 7 Count
B 9.5% 31.6% 30.4% 30.7% Profitability
B 2 3 3 3 Count
C 22.4% 23.6% 16.6% 17.6% Profitability
C 15 16 17 18 Count
D 19.2% 20.5% 15.9% 13.7% Profitability
D 8 8 9 10 Count
I have successfully generated a stacked bar chart that shows the counts per
group by year.
Now I would like to include a label for each group to show profitability for
each group in each year in the 4 stacks. How would I do that?
--...Creating a chart based on the data in an embedded worksheet
I have a worksheet with several embedded worksheets. I would like to
create a chart based on the data of one of the embedded worksheets
without putting the chart in the embedded worksheet. I have tried
unsuccessfully to do this. I just wondered if anyone knew how to do
You're embedding worksheets within worksheets? Why? Why not just insert
the worksheets in line with the main worksheet? To open or edit the
embedded worksheet, the parent Excel has to open another instance of
Excel, and the chart on the outside of this other instance will never be
able to acce...Installed Font does not display in Word 2007
Only 6 of of 8 recently installed TTF fonts will display in Word 2007
Are the missing ones variants like Italic or Bold?
On Dec 25, 1:28=A0pm, GWHA <G...@discussions.microsoft.com> wrote:
> Only 6 of of 8 recently installed TTF fonts will display in Word 2007
...Why will my publisher 2003 not print graphics?
I have recently loaded windows 7, and since then I cannot print any graphics
from any publisher document, text and infills print but lines do not! I have
looked at the advance printer settings and the "Do not print any graphics"
box is not ticked.
I have also tried reloading publisher but this did nothing. Any ideas anyone?
Might take a look at the web site of your printer model to see if there are
Windows 7 drivers. Will the document print okay if you convert it to PDF?
There are free converters around. www.primopdf.com is free.
It is always wise to completely remove ...How can I print on 8 1/2"x17" paper?
I have cut down an 11x17 paper to 8 1/2" x 17". I cannot figure out how to
change the paper size to accept and print anything bigger than 14." any
suggestions would be greatly appreciated
First make the size settings in the Printer Setup. You may need to use the
"mickilena" <firstname.lastname@example.org> wrote in message
>I have cut down an 11x17 paper to 8 1/2" x 17". I cannot figure out how to
> change the paper size to accept a...Cannot Drag Open Desktop Screen
I have a friend running XP MCE (2005) SP3 and he cannot drag an open
screen on his desktop by Left clicking and holding cursor on the top of
Any suggestions as to how to remedy this problem of not being able to drag
a screen will be appreciated
On Sun, 14 Mar 2010 16:48:43 -0400, "ColTom2"
> I have a friend running XP MCE (2005) SP3 and he cannot drag an open
>screen on his desktop by Left clicking and holding cursor on the top of
> A...mysession & deleting a line item on the pos screen
I want to automatically have my dll delete a line on the pos screen. So I
have tried to do a myssion.transaction.entries(1).Delete and other sorts of
things. Does anyone know of a way to accomplish this?
Thanks in advance for any help on this.
Use code like this:
For Each item In mysession.Transaction.entries
If FindItem(item.item.id, item.quantity, item.item.description) Then
> I want to automatically have my dll delete a line on the pos screen. ...Formula to display nearest following Thursday in mm/dd/yyyy format
I have been reading and trying different suggestions here to no avail. What
I need is a formula to calculate the nearest following thursday, and display
it in mm/dd/yyyy format.
To be clear, I have a column of varying dates. I need a formula to return
the next thursday for each of those dates.
To illustrate, say I have 05/22/2010, 05/23/201, 05/24/2010, & 05/26/2010 in
cells A1 through A4. In cells B1 through B4, I would like to see 05/27/2010,
05/27/2010, 05/27/2010, & 05/27/2010 representing the following thursday.
Thank you for your help!
T...Data validation list from another worksheet?
Is it possible that the value list for data validation be populated fro
puneetarora_12's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1840
View this thread: http://www.excelforum.com/showthread.php?threadid=38572
Sure is! Use a named range as described here:
"punee..."external data sources" and "external data ranges"
what is the difference between these?
i have run the vb macro code on http://support.microsoft.com/kb/330383 to
check if i have any external data sources or data ranges but there are none.
the reason i need to know is becuase i'm working with office sharepoint
server 2007 and i cannot access a file thru the web access web part because
"The workbook that you selected cannot be loaded because it contains the
following features that are not supported by Excel Services:
External data ranges (also called query tables)"
...Printing problem in booklet format
When I try to print my booklet document, on the screen it looks perfect, but
when i go into print preview it only has half of each page on the paper.
When i print, it comes out exactly like that. I have Publisher 2003 and run
it on XP home. My printer is an Epson stylus Photo RX650. I contacted Epson
and they say its a Publisher problem. Any suggestions.
Are you selecting booklet in page setup? Do you ...Print preview distorts objects
I have an XL2000 worksheet that has 4 controls on it (one
command button, and 3 radio buttons). When I print
preview the worksheet, once I close the print preview
window the controls become distorted in size and
location. Has anyone ever encountered anything like this?
...Printing a newsletter on 11x17 not in full size
I am trying to print my 4 page newlsetter that is 8.5x11 on 11x17 so that it
is a folded newsletter. It prints on the 11x17 but it keeps printing small
with crop lines. It is in the right order but not full size. PLEASE HELP
What version Publisher? Are you using Publisher 2007?
Are you setting up your printer first for 11 x 17?
File, page setup, booklet, select custom size 8.5 x 11, click advanced on the
right, select booklet in the pull down
type 8.5 width
Mary Sauer MSFT MVP
"Tam Nee...Source data, in Chart Menu, is grey and not accessible.
I set up a pivot table and designed a chart, saved and closed out of the
workbook. Upon returning to work on this project, when selecting the chart
menu to work with my source data, the source data is grey and not accessible.
What might be causing this and can I correct it?
It's a pivot chart. As soon as it's created, it's linked permanently to the
pivot table, and you cannot change the source data. you cannot add more data
that's not in the pivot table to the chart, nor can you remove data that is
in the pivot table from the chart.
Jon Peltier, Microsoft...PRINT PREVIEW #6
I REVIEW A PRINT PREVIEW AND AM OK WITH IT. I SAVE THE FILE AND WHEN I
RETRIEVE THE FILE THE NEXT DAY THE PRINT PREVIEW HAS CHANGED. WHAT IS
What has changed?
remove CAPS in email address
"RON" <RON@discussions.microsoft.com> wrote in message
>I REVIEW A PRINT PREVIEW AND AM OK WITH IT. I SAVE THE FILE AND WHEN I
> RETRIEVE THE FILE THE NEXT DAY THE PRINT PREVIEW HAS CHANGED. WHAT IS
...printing problems with memorized reports
We have recently been running into printing problems with our memorized
reports. We will print preview a report and it will look fine on screen,
then we will send to the printer, and the report print extremely small in the
corner of the page. However if we go back in and re-print the report then it
will print normal size on the page. We are not making any settings changes
at all, and when it does this appears to just be at random. We are printing
to an HP laserjet 4000 series printer that is on our network. We've used RMS
with the same configuration for approx. 5 years now and ...Add message to customers on printed invoice
We should be able to add a message to customers (holiday hours, holiday
message, etc.) to an invoice. Even QuickBooks has this ability, why doesn't
Director, Information Technology
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
ht...How to display a hyperlink without the underline in Publisher
Sending a mailshot - dont want to use gifs for design - so used text boxes
which are hyperlinked - but I dont want the underline - can anyone please
tell me how to display the text without. Thanks
You can't eliminate the underline. You could create a thick white line to cover
the underline or a small rectangle, no line, white fill, no wrap. Of course this
will cover the hanging parts of your font.
Mary Sauer MSFT MVP
"Sally" <Sally@discussions.microsoft.com> wrote in message