Operating System: Mac OS X 10.6 (Snow Leopard)
In a previous version of excel, there was a open bar at the top that you could click on to edit the text in a cell, rather than retype the text into the cell you were working on. The text from the cell would appear and you could backspace and/or add in additional text that would then appear back in the cell. Any body know how I can get this?
What you're looking for is the Formula Bar. Select if in the View Menu.
On 1/19/10 8:37 PM, in article 59bb1451.-1@webcrossing.JaKIaxP2ac0,
&quo...email text missing when sent
I compose an email within Outlook and send it. The sent
email only contains the first character of the text. The
recipient of the email does receive it, but with only the
one character in the text. When I look at the copy of the
email in my Sent folder, the text only has one character.
I repeated the process several times with the same result.
The above was done with my Options set to Rich Text. When
I change my Options to use HTML, everything is sent fine.
This problem just occurred yesterday. I've been sending
emails without problem for months. I didn't change any
set...Formulas coming up as text
Formulas continue to appear as text and will not calculate. how to get
formulas to always calculate.
If your formulas appear as text, then you need to first clear the cells
before entering formulas. Select the cells, hit Edit-->Clear-->All. Save the
file, format the column as General, and try again.
"cheryl" <firstname.lastname@example.org> wrote in message
> Formulas continue to appear as text and will not calculate. how to get
> formulas to alway...VBA Text Color
I would like to change the text color to Red for a string being returned to a
window through vba when certain conditions are met.
I can see the vbRed control but cannot get it to work, Object Required.
Has anyone been able to change the text color through vba, and how is it set?
I don't believe VBA can directly change the colours on a Dexterity field or
window. You can use the unsupported but very useful method of pass through
Dexterity SanScript to change the colour of the text or the background.
I think you already have the company background colour VBA example. I...Can't have a null value if another field has text.
I have tried a few different things to try and get this to work, but I
can't seem to figure it out. Basically, I have a form with some text
boxes linked to fields on a table, and I want one of two things to
happen (the first one would be preferred, but if that's not possible,
the second would be just as good):
1) If Field 1 is updated to a Null value and Field 2 has text in it,
move the text from Field 2 to Field 1 and change Field 2 to a Null
2) If Field 1 is updated to a Null value and Field 2 has text in it, a
message box pops up that essentially says "You can't do ...Calculation of Area Under a Continuos curve......Scatter Curve.
The variables are part of a scatter diagram, i.e. the variables
plotted on X axis do not have any defined relationship with the
Variables of Y axis......
Hi, I am working on calculating area under a Continuous Curve.. I
have data poitnts...On X axis i have % of Cumulative numbers(Variable
X) and on Y axis i have % of Cumulative numbers(Variable Y). If i
plot a curve by joinig thses points i get a smooth curve. If i have to
calculate the exact area under the curve using Integration Function in
Excel Sheet how should i proceed.
Data points are :
Issuers Defaulters Cum Issuers % ...Journaling #3
I'm using Exchange 5.5 and I'm currently testing the messages journaling
feature. But not all messages are catch. The message sent by an employe to
another employe are not catch and some from external person are not catch
too. Can someone explain me why ?
Did you follow the KB article for setting this up?
On Wed, 26 Jan 2005 10:56:53 -0500, "Charles Demers-Tremblay"
> I'm using Exchange 5.5 and I'm currently testing the messages journaling
>feature. But not all messages are catch. The me...Adding text to a form
I tried to find an answer today but I could not
I wan't to insert a stic help text in the accounts form. I do not want
to use popups I jest want to put a text in the bottom of the form
How do I do this?
I had the same problem - I ended up creating a section to use that as my
static text. You would think there would be a better solution that that, but
I could not find any.
> I tried to find an answer today but I could not
> I wan't to insert a stic help text in the accounts form. I do not want
> to use popups I jest want...How to show multi-line text on a tooltip(CToolTipCtrl)?
You can use SetMaxTipWidth and then use \r\n to break lines.
Thanks a lot!
I used SetMaxTipWidth( 1024 * 8 ) to support this feature successfully. But
there is not any official documents from MS I can find to introduce
that SetMaxTipWidth can produce this effect. So maybe I wanna do more test
on different Window OSes.
"Ajay Kalra" <email@example.com>
> You can use SetMaxTipWidth and then use \r\n to break lines.
You could try this control that Dun...Probl�me to start reporting with CRM 3.0
We have the CRM 3.0. In fact I made a report with visual studio
2005 with SQL Server 2005. The report has a hidden parameter. When I
The visualized with visual studio, it works well. But when I includes the
Level of CRM and try to start my error:
"Reporting Services Error"
"For more information about this error navigate to the report on the server
Local server machine, or enable remote errors "
"SQL Server Reporting Services
Think you for your assistance
Are you using a shared data source in your report?
If you run the report directly from the CRM server, it...Formatting text string
Justify Distributed: I'm trying to redistribute a single long text string
from one cell (continued over may cell in that same row) to an area below
consisting of several rows and cells. Note: I thought that in the pest I
accomplish this by selecting the intended area and then formatting re Format
/ Justify Distributed. But now that box is grayed out. Is that formatting
option no longer available?
Ops! I forgot to mention... We're running Excel 2002.
"Paul from B I" wrote:
> Justify Distributed: I'm trying to redistribute a single long tex...Error 8108 #3
Category: Service Controller
Event ID: 8108
Description: The initialization process failed.
This error is running every 5 minutes on our DC. Anyone have any ideas? I
checked TechNet article Q317210 and it didn't pertain at all to our
situation. We have no child domains, we're running in AD mixed mode, and
all of our Exchange servers are enterprise edition, not standard as
mentioned in the article.
Is there Exchange 5.5 or ADC running in your org? This
error event may caused by ADC replication. So please
temporarily step ADC and then check the issue again....How do I keep text from automatically filling in another text box
When I fill in a text box, the same text automatically appears in another
text box. I don't want that to happen. I want each box to be filled
Click in the test box that you don'e want the text to continue and then
click the "broken chain link."
"Chicago" <Chicago@discussions.microsoft.com> wrote in message
> When I fill in a text box, the same text automatically appears in another
> text box. I don't want that to happen. I want each box to be filled
> in...Data Migration Framework v3.0 from ACT to CRM 3.0
I want to migrate ACT in to CRM 3.0. My company is trying CRM 3.0
implementation but we dont want to put in any initial costs of buying SCRIBE
data migration tools. So we are trying out DMF to do this migration.
My questions are:
1. Can i migrate ACT Accounts as CRM Marketing Leads?
2. If yes to previous Q, Then existing DMF ACT To CRM spreadsheet does not
have the Data Mapping for Lead Table
3. Our ACT accounts are categorised in different groups based on the
Industry, Can i migrate data as CRM Leads with same Industry specific groups?
I have a very tight deadline to implem...Delete text
Operating System: Mac OS X 10.5 (Leopard)
Can't delete marked text by pressing BACKSPACE
Well, since the Mac keyboards I'm familiar with don't have a BACKSPACE key
I'm not sure what you're pressing :-) but it's most likely a matter of going
to: Word>Preferences> Edit, check the box for "Typing replaces selection".
On 2/9/10 11:15 AM, in article 59bb2874.-1@webcrossing.JaKIaxP2ac0,
"IO@officeformac.com" <IO@officeformac.com> wrote:
> Version...validation list drop down box, how do I bring in text commands
I have a reference set in excel that is two columns. The first column lists
functions in text (i.e. AVERAGE, COUNT, COUNTA, MAX, MIN....). The second
column lists the corresponding function number (i.e. AVG = 1, COUNT =2....).
I made a drop down box using data, validation, list so that the function
numbers appear in a row. The row below I put in subtotal(grab command from
drop down, data set to calc). I can't figure out how to return the TEXT from
my columns above, rather than function number. I want my drop down to have
AVERAGE, not 1.
Debra Dalgleish has pages ...Is it possible to display text in charts?
I am creating graphs for results from a survey. Part of this is to graph each
individual's response to every question.
If a person did not answer a question, I would like "N/A" to appear in the
data for the chart.
I am not using formulas -- the numbers are typed directly into the
spreadsheet. Is there any way to have the text "N/A" display in the chart
data? Currently, if I enter text in the corresponding cell, it displays as
"0" in the chart data.
You can try applying a custom format to those entries that are coming across
as zero....Entering wrapping text
I have two issues when entering text in an Excel cell.
I format the text to wrap, and the row height increases
to accept additional text as I type. Sometimes this stops
happening, and I have to resize the row manually.
How do I control this? Also, although the row size
increases as I add text, it doesn't seem to decrease if
I delete text. Is there any way to make this happen?
When I format the text as "general" it displays correctly
in the cell (although in the sample pane it displays as
##################). When I format the text as
text it displays as ################### in bo...randbetween #3
can you tell me what distribution the rand between function uses and a graph
would help a lot
> can you tell me what distribution the rand between function uses and a graph
> would help a lot
...Word auto text (normal.dot)
Can you add Words auto text (normal.dot) to an Excel Spreadsheet?
Excel doesn't have a Normal.dot (like MSWord).
But it also doesn't have autotext, either.
But just like MSWord, Excel does have Autocorrect--maybe that could work for
And it does have an autocomplete feature (limited to column by column data
You can toggle this setting via:
tools|options|edit|check "Enable AutoComplete for cell values"
Remember how you toggled this--it can be irritating when you don't want it on
> Can you add Words auto text (normal.dot) t...Using text from cell in a formula
I am trying to use text from within one cell to be used in a formula of
another to reference a tab name. See below for example:
I want to be able to reference the text "SOG" for the tab name in the
formula. That way I don't have to type the name twice.
=INDIRECT("'" & A1 & "'!F4")
<firstname.lastname@example.org> schrieb im Newsbeitrag
> I am trying to use text from within one cell...change color in many text box
I have a form which takes information from a query.
The information is orizontally aranged in the many text boxes .
I would like to know how can i change the background color of the text box
on the row by just doubleclicking on that particular row.
Give me some suggestions please!
"florin" <email@example.com> wrote in message
>I have a form which takes information from a query.
> The information is orizontally aranged in the many text boxes .
> I would like to know how can i change the background colo...Excel Report Builder #3
I'm trying to setup security for users to access and use Excel Report Builder
and followed what the user's guide directions:
1. Open the Security Task Setup window (Microsoft Dynamics GP menu >> Tools
>>Setup >> System >> Security Tasks)
2. Enter a Task ID, Task Name, Task Description and Category.
3. Select SmartList Builder as the Product and Excel Report Builder
Permissions as the Type and Series.
4. Mark the operations that you want to grant access to for the selected
user or user class.
It grants the user access and appears the capability to build and...Curve radius
I use Visio 2000 (SP2) and have Accident Reporting and Crime Scene
add-ins to create scale diagrams of traffic accident scenes. Is there
any way to automate curve length, chord and radius? Any tip that allows
the use of the "Size & Position" window would be most helpful, but any
tip at all will be appreciated!
I have used Visio since 2000 came out and am comfortable with it, i.e.,
I can use it to automate other shapes, but I dont see any where to
Thank you in advance!
It can be automated by creating some VBA code. Most highway and residential
curves are comp...calibration curve
I am setting up a chemistry calibration curve using data below
OD reading Concentration
..245 40 etc
Plotting in XY scatter chart and get trendline using polynomial function.
How can I determine the concentration of an unkown solution ? I want to use
trendline data to do this.
Put the Conc data in column A and the OD data in B
You can have headers ("Concentration", "OD" ) in row 1
Let's say the last row is 10
Select A1:B10, click the chart tool, select XY chart, use the first subtype