Text box in chart disappears but reappears when in spreadsheet
Has anyone any idea how to prevent a text box that's in a graph from
disappearing when the graph is selected, but reappearing when cursor is back
in the spreadsheet? This never used to happen before, but only recently has
begun occuring with our graphs. Thanks!
That behavior would suggest the textbox is not embedded in the chart but
just placed over it. Can you move the textbox away from the chart?
If yes then delete the textbox and then select the chart and paste.
> Has anyone any idea how to prevent a text box that's in a graph from
> di...Parsing Question
I've done parsing where you have one delimiter such as a comma or
What if you have more than one?
sStr(0) = "3/9"
sStr(1) = "3/11 3/15-"
sStr(2) = "3/8+ 3/12"
sStr(3) = "3/9 3/15"
sStr(4) = "3/8- 3/10+ 3/15"
The strings above are Month/Day with some having an additional - or +
character next to it.
These dates are extracted from Excel cells as strings.
I need to break those strings down into individual dates.
So for sStr(4), I need to parse out "3/8", "3/10" and "3/15&...Date column defaults
Outlook's default date column is 'Best Fit'. I'm not sure quite what this
means, but I prefer the more compact dd/mm/yyyy (UK).
Is there any way to change this globally or do I have to laboriously change
Can I change the default for new columns?
Jonathan Finney <firstname.lastname@example.org> wrote:
> Outlook's default date column is 'Best Fit'. I'm not sure quite what
> this means, but I prefer the more compact dd/mm/yyyy (UK).
It means that Outlook decides the width of the field. The date format
display in the f...Text size #4
I'm sure this is probably very easy! but I can't find any way to increase
the size of an email in the viewing panel of Outlook, is there a way to do
this and possibly to add a button to the toolbar to enable easy resizing of
"Harry Limey" <harrylimey(at)Lycos.co.uk> wrote in message
> I'm sure this is probably very easy! but I can't find any way to increase
> the size of an email in the viewing panel of Outlook, is there a way to do
> this and possibly to add a button to the toolbar...Text list to graph
I have a column listing car makes in random order with duplicates:
QUESTION: How can I create a chart from this list?
I've tried sorting, then sub-totaling. Am I on the right track?
Thanks, Mark Flynn
You can summarize the data with a Pivot Table, and create a chart from that.
Add a heading to the list, e.g. Cars
Select a cell in the table.
Choose Data>PivotTable and PivotChart Report
Select PivotChart report (with PivotTable report), click Next
Select the Data range, click Next
Drag the Cars button to the Row area
Dr...Date Stamp on CRM Email Templates
Client would like to be able to have the ability to add date and time to the
email template. Is this template function (data) avaliable to select from in
CRM 3 or 4. Using the server time for example.
...how to parse <?xml version="1.0" encoding="UTF-8"?> with xpath? is it possible?
how to parse <?xml version="1.0" encoding="UTF-8"?> with xpath? is it
"Daniel" <email@example.com> wrote in message
> how to parse <?xml version="1.0" encoding="UTF-8"?> with xpath? is it
No -- the xml declaration is not represented in the XML Infoset.
...Time and date on an invoice.
How can you tell what user edited the invoice and what time they did so. I am
The audit trails in V8 were weak and your options with the base code are
limited. There are fields in some tables called something like CreatedID or
CreatedUserID (but very much abbreviated) along with creation dates. Some
tables have last modified user and date/time.
Look at the tables you are working with in Resource Descriptions to see if
they have these fields. You will need to access them through a report writer
or Smart List Builder.
There are some 3rd party tools availab...Date conversions....Excel thinking too hard?
We have many programs (Access, SAP, etc.), that when they
try to export to Excel, Excel always tries to convert our
part numbers into dates.
For instance, we have a part number, 1944-1-5, that needs
to be exported to Excel as a text value, 1944-1-5, not
converted to a date, like 1/5/1944.
And no, putting quotes around it is not practical, since
we have thousands of part numbers.
I have successfully exported from Access using the
TransferSpreadsheet method in a macro or VBA (instead of
the standard "File | Export..." menu selection) without
the date conversion occuring. Ho...Conditional formula with text and number in cell
Can a conditional formula be written to convert a cell with text and a
number to a cellw ith just a number?
I have a cell with the number 10 and the word "weak" in it. 10 weak
Can a conditional formula convert this to just the number "10"? I did
=If(b1= 10 weak,"10") but it does not work.
=3DIF(B1=3D"10 weak",10,"not 10 weak")
BTW............10 weak what's?
10 weak kittens?
10 weak cups of tea?
Gord Dibben MS Excel MVP
On Sat, 29 May 2010 11:47:01 -0700, RichM =
<RichM@discussions...Great Plains SOP Table Date Fields
I looking for clarification on what DOCDATE and ORDRDATE are in the SOP
tables. I believe that DOCDATE is the date the line was entered and that the
ORDRDATE is the date that the date that the Order goes into effect. Could
anyone clarify this for me?
Go to the SDK and look at SOPTRX.RTF. It is the Sales Order Transaction flow
by table and field.
"Chris Hornung" wrote:
> I looking for clarification on what DOCDATE and ORDRDATE are in the SOP
> tables. I believe that DOCDATE is the date the line was entered and that the
> ORDRDATE is the date that the date that the...Appointment End Date
As soon as I enter a Start time in Outlook 2007's appointment calendar, the
End time date jumps to the next day. How can I make it stay on the Start
"sumacny" <firstname.lastname@example.org> wrote in message
> As soon as I enter a Start time in Outlook 2007's appointment calendar, the
> End time date jumps to the next day. How can I make it stay on the Start
> date? Thanks.
If you are double-clicking on a date in the Month view, then you are creating
an all-day event ...Dates #3
when i pivot information into a chart it changes date
formation from MAR-2003 to 18/03/2003. how can i change
Double click on the dates, click on the Number tab, and select the desired number
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
> when i pivot information into a chart it changes date
> formation from MAR-2003 to 18/03/2003. how can i change
> this back.
...Graph displaying dates alphabetically on x axis, not by date
Title says it all - I want the x axis to show dates in DATE ORDER, not
I've read thru the forum, can't see how to fix it - your help will be
p.s. Here is the graph Row Source, should there be an ORDER BY statement in
SELECT (Format([Date Paid],"mmm"" '""yy")) AS Expr1, Sum([Tenant Payments].
Amount) AS SumOfAmount FROM [Tenant Payments] GROUP BY (Format([Date Paid],
"mmm"" '""yy")), [Tenant Payments].[Date Paid], (Year([Date Paid]...Dates
I am working on a spreadsheet that consists of a rolling 12 mont
period. Once a month has passed how do I delete it and add a new mont
to the 12 month period? Please help
~~ Message posted from http://www.ExcelForum.com
You have to provide more info on how your data is laid out. Tell us what
you have and tell us what you want to have when the month changes. HTH
"erodri02" <email@example.com> wrote in message
> I am working on a spreadsheet that consists of a rolling 12 month
> period. Once...Date filled down?
I would like to put a date in a cell.
Then fill it down. How to do that?
Tuesday, July 06, 2004
Wednesday, July 07, 2004
type the date as dd/mm/yy or mm/dd/yy or whatever is default for your
then choose format / cells
click on custom, type in the box on the right had side
dddd, mmmm dd, yyyy
now click on fill handle (bottom right of cell) and fill down as far as you
want - adjust column width if needed.
"Ming He" <firstname.lastname@example.org> wrote in message
news:e$4TSb9YEHA.3304@TK2MSFTNGP09....Date Prompts in Subreport
Is it possible to combine 2 reports together if they are both based on
queries that require date prompts?
The reason I am asking is that I have 2 reports of employee time, each for a
different department. Both are based on queries that have the criteria
Between [Beginning Date:] and [Ending Date:]. That way, when each report is
generated, the user can select the date range to display. Now, I am trying
to combine them so that they both show up on the same report. I tried making
one a subreport of another, but when I try to run the report, I keep getting
the date prompts over and ove...How I can specify the length of a text or binary column to larger value?
When the using Microsoft Excel How I can specify the
length of a text or binary column to a larger value?
otherwise, if the length of a text or binary column not
specified (or is specified as 0), the column length will
be set to 255.
not really sure what you're trying to achieve?
"Yue Wu" <email@example.com> schrieb im Newsbeitrag
> When the using Microsoft Excel How I can specify the
> length of a text or binary column to a larger value?
> otherwise, if the lengt...Date time picker control cannot set time from CTime mapping
I have a dialog with a Date Time Picker control. Using Class-wizard i have
mapped this to a CTime data member in my dialog derived class. Im trying to
set this member with a date value on initialisation but it defaults to a 1970
The dialog class has the following member
In the DoDataExchange there is
DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER3, mExpireDate);
mExpireDate = rec->GetExpireDate().GetDate();
Where GetDate() returns a valid time_t value.
retreiving the set value from th...Parsing cells
I have data in cells which is OCR`d from my phone bill, and
some of the info is corrupt. Where I should be getting eg. 17 Nov 14:49 for
date/time I am getting O17 Nov 14:49 or
C17Nov 14:49. The reason is that there are unreadable icon characters to
signify day or night.
1)How do I remove the faulty characters......they are always the first digit
in the date if they are there.
2)How can I seperate the date and time into two adjasent colums of cells
rather than their current format in one cell.
Any and all help greatly appreciated. John
You ca...calculating dates #2
What formula do i use???
here is my problem... i have 3 columns
A- Qty of days eg: 6, B-start date, eg: 10/12/07 C -end date, , (formula i
am using, (colummn (C) =A+B+1 (copied down the column) this gives me an end
date by adding A and B which i use in a gantt chart, eg; "but" some dates do
not have a start date yet and the end result will read (C) 05/01/00, how can
i get column (C) to remain blank until i put a start date in????
Microsoft MVP - Excel
"spudpeeps" <firstname.lastname@example.org...email format is changed from HTML to Text
I haven't done any research on this, I hope someone has the answer.
Sometimes when I reply to a message, the email format is changed from HTML
to Plain text automatically, It does't happen when I am writing a new email,
it is just sometimes when I am replying.
Are you sure that the message to which you are replying is HTML and not just
plain text with foreign encoding? For example, I set the encoding for this
message to Turkish, but it is still plain text. It just doesn't appear that
way (to me anyway, and possibly also you).
Ray at work
"Alex Perez" <aperezny@h...Address Book Not Working With Text Messages Sent By Outlook
Every time I try to send a text message per Outlook, I can type and send the
message, only as long as I physically type a person's name in the To box. If
I click on the little address book button beside the To box or click on the
icon at the top of the message page, I immediately get kicked out of Outlook,
and it must restart.
Does anyone know what is wrong and how it might be fixed?
What version of Outlook? What type of email account?
It sounds like the address book is corrupt. If you use outlook 2003 or
older, try this: go to Tools | Email Accounts, choose Vie...text disapearing in a text box
I put a text box on a chart. After typing it in (it was a long text) I saved
the chart I could still see all the text. After I saved it, I created a PDF.
It was still fine. After I closed excel. The next time I opened the chart
part of the text was gone. I tried to resize the text box, but part of the
text was still gone. When I oringinally save the chart I didn't get an error
message about the size and the pdf after the save showed all of the text.
I am working on a spreadsheet that someone else created. The dates are set
as e.g. 13.03.09 - I want this to read 13/03/09 I have tried formatting cells
to date dd/mm/yy and clicking ok but it doesn't alter anything. Apart from
going in and altering each cell individually nothing else seems to work.
> I am working on a spreadsheet that someone else created. The dates are set
> as e.g. 13.03.09 - I want this to read 13/03/09 I have tried formatting cells
> to date dd/mm/yy and clicking ok but it doesn't alter anything. Apart from