My text seems stuck in the text box! I can't make changes!HELP!
I am trying to alter text just typed into a text box using Publisher 2003.
For some reason, the system will not allow me to go back to edit.
Is your application activated?
Is it just this one text box in this publication? Are you working with a
template? Select the text box, copy, paste, can you edit the pasted text box?
Mary Sauer MSFT MVP
"Learner" <Learner@discussions.microsoft.com> wrote in message
>I a...Can I change the font color of text inside an IF statement?
Here is the equation I'm using in Excel 2003.
I would like the text color to change red if:
IF NO is selected and B1-E3 >2 I would like the text to turn red.
IF YES is selected and B1-E3 >4 I would like the text to turn red.
If I can do this in conditional formatting, that’s fine, I'm just not
familiar enough with excel to do this.
Thanks for the assistance!
a formula can't change a format.
But have a look at 'Format - Conditional Format' fo...Best way to store image, voice, text file?
Is it possible to define a sql server field to store image, or voice, or
If the size of the file is very big, thus exceeding the max row size 8064
bytes limit, is it better to store it in a directory, and just save the
location of the file in the field?
On Thu, 1 Jul 2010 07:19:54 -0700, Ben <Ben@discussions.microsoft.com>
>Is it possible to define a sql server field to store image, or voice, or
>If the size of the file is very big, thus exceeding the max row size 8064...copy/paste excel to texteditor -> multi-line text cells gain unwanted double-quotes
i have a formula composed of 3 lines in one cell:
=" IF c_MSISDN_NDC" & $E3 & " IS NOT NULL THEN
utl_file.put_line (l_file_handle, '
'||c_pkg||LOWER(l_curr_table)||'(c_new_point +" & $E3 & ", 1,
utl_file.put_line (l_file_handle, '
'||c_pkg||LOWER(l_curr_table)||'(c_new_point +" & $E3 & ", 2,
this produces a text string, e.g. as below:
" IF c_MSISDN_NDC70 IS NOT NULL THEN
utl_file.put_line (l_file_handle, '
'||c_pkg||LOWER(l_curr_t...Keep quoted numeric characters as text.
Is there any way I can keep Excell from converting double
quoted strings of numeric characters to a number when
opening a .csv file?
I have a column where sometimes the text being imported
is something like "001". I need to load it as text '001'
instead of as a number 1. If I change the column to text
after opening the file, the leading zeros are still
In MacXL you can open it directly with Text Import wizard. With WinXL
you need to change the extension (say, to .txt) first. Then set the
column to Text in the third pane of the wizard.
In article <043b...Can you expand/collapse columns based on a reportitem/field values
I have a report that is driven by accounting periods. The columns are 1, 2,
3, Q1, 4, 5, 6, Q2...YTD. Currently when the report opens all that is shown
is Q1, Q2, Q3, Q4, and YTD and the user can expand from there. What I want
to happen is, if we are in Q2, I want columns 4,5,6, Q2 to be expanded. So
the report should read Q1, 4,5,6, Q2, Q3, Q4, YTD. Is this possible?
Thanks in advance
I created the following dataset:
SELECT 'Q1' AS Expr1, 1 AS Expr2, 500 AS Expr3
UNION ALL SELECT 'Q1' AS Expr1, 2 AS Expr...Remove text from a cell
I have some data in a spreadsheet which is an output from another program.
One column has a series of numbers in it, each with the suffix of "kb" and I
want to remove the kb from each cell so that I can sort by number. Is there
an easy way to do this without having to edit each cell individually (I have
about 600 rows!)
one way: Use 'Edit - Replace'
the other way: use the formula
in a helper column
>I have some data in a spreadsheet which is ...text in charts
Is it possilbe to have a textbox in a chart, that
actaully corresponds to a cell entry in the spreadsheet,
to change its contents for whatever I type in the cell?
is it possible for the title too?
To add worksheet text to a chart:
1. Click on the chart to select it.
2. Type an equal sign (you'll see it appear in the formula bar)
3. Click on the cell that contains the text for the chart
4. Press the Enter key.
5. Position the textbox where you'd like it in the chart,
and format as desired.
> hi all..
> Is it possilbe to have a te...XML error "Some Data Was Imported As Text"
Daily, I recieve a 3rd party XML file that I parse in Excel (using an excel
macro) and then import into an Access database. Infrequently, the data will
import into Excel, then parse and then the routine stops with the error
message above. I look through the raw XML file and everything appears to be
within the brackets, etc.
Can someone give me some clarification to the meaning of the error message?
Thanks in advance and Mery Christmas and Happy Holidays!
The error message might be generated within your macro - as it is
parsing the data it might detect that some field which should be
...Text Manipulation from PDF
Really weird problem I have with a report generated by a application at
work. I run off a monthly report of products completed by employees. It
shows the following info in a pdf report
User ID No of Products Date Sub
Date Last Sub Last Date Sub
Smith_0001 5 01/01/2006
Brown_0002 8 02/01/2006
Etc but it lists about 300 staff when I copy it and paste it int...Adding text and date problem
I have text in column 1, a date in column 2 and in column 3 I wish to
show the text followed by the date.
I have tried both Concatenate and & but the the result is text followed
by the underlying number representing the date. I cannot seem to format
this column to show the date as dd/mm/yy. Any suggestions?
="Today is: "&TEXT(A1,"mm/dd/yyyy")
Microsoft MVP - Excel
"newman" <firstname.lastname@example.org> wrote in message news:464C1646.AC6A42E0@despammed.com...
|I have text in column 1, a date in column 2 and in column...How to full justify text ?
Help! I have tried many things but can't figure out how to full justify text.
Format, Cells, Alignment, Under Horizontal, choose Justify.
WordAngel Document Design
> Help! I have tried many things but can't figure out how to full justify text.
...converting checkboxes to a text value
I have an existing database that employs checkboxes. I'd like to create a
report that displays those boxes as "yes/no" text values, so that I can
export them to an .rtf format, and have them actually show up.
I'm a novice, so any help is greatly appreciated.
The purpose of this is to be able to email specific pages of the report.
I'm also open to other ideas for making this possible, if I'm going about
this the wrong way.
Thanks in advance.
> I have an existing database that employs checkboxes. I'd like to
> create a report that...Text and backgound do not print
I have created a folding leaflet which appears fine on the screen. However,
when I click on print preview, half of the leaflet appears only as a white
space. When I print it, I get the same result, i.e. only half of it appears
on the page. Can anyone help, please?
Try running Design Checker on your leaflet. Sometimes issues will show up
that that prevent items from being printed. I just helped a woman with a
very similar issue. I deleted some extra text boxes and it's fine. ;-)
MVP Microsoft [Publisher]
How to ask a question
http://support.microsoft.com/...Text emails do not format
All of my incoming emails in Outlook 2003 are coming in as
one long line of text. I've gone into my email options
and turned off "Remove extra line breaks from text emails"
but the problem still occurs.
Does anyone know how to prevent my incoming text emails
from turning the entire message into one long paragraph?
Maybe the issue is with the person (or people) sending it.
As a test, log into your webmail account, send yourself
and email and then go into Outlook 2003 and see what it
>All of my incoming emails in ...Receiving messages with no text.
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: pop
When receiving new messages, I can view content and attachments on some <br>
mails but not on others. Subject bar and name is always visible. There's no <br>
pattern either as to which mails work and which don't. Have rebuilt <br>
database, but with no apparent success.
On 1/26/10 9:35 AM, email@example.com wrote:
> When receiving new messages, I can view content and attachments on
> some mails but not on others. Subject bar and name is always vis...Importing text using get external data
I have created a query spreadsheet that gets certain data from another
spreadsheet (call it data spreadsheet).
The data spreadsheet has a column where text is stored, which in some
cases exceeds more than 255 characters. The query that imports such
data truncates the text to the first 255 characters.
Is there a way around it ? Any input will be appreciated.
Message posted from http://www.ExcelForum.com/
...Change "Y" axis from integer to text
Is it possible to change the range on the Y axis from
numbers (0-50-100) to text (low-medium-high) without just
placing text boxes on the chart? Please let me know how!!
You can simulate the effect. See
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <firstname.lastname@example.org>,
> Excel 2k
> Is it possible to change the range on the Y axis ...How to combine text from 3 cells into 1 cell with space and ", bet
How to combine text from 3 cells into 1 cell with space and ", between. Is it
a formala I can use?
Try this =A1&" "&""""&B1&" "&""""&C1, adjust range to your needs
"JOF" <JOF@discussions.microsoft.com> wrote in message
> How to combine text from 3 cells into 1 cell with space and ", between. Is
> a formala I can use?
...Plain Text in outlook 2000
In Outlook 2000 with SP2 installed we are unable to send
e-mail in plain text. For example: I changed all the
setting within outlook to send and receive e-mails in
plain text. Every time I open a new one or reply it reads
a rich text not plain text. I am able change it manually
to plain text but we want it to automatically do it in
We have tried all the settings inside Outlook and the
recommend change to the registry:
The mailto protocol for IE is set to OUTLOOK.EXE -c
IPM.Note /m "%1"
Still does not work
Anyone have any Ideas
Outlook Profiler can set thi...excel
I am trying to write a macro to save a excel spreadsheet and use a cell that
contains text like a customer name.
Record your macro to include the File > SaveAs, then edit that line of code.
Instead of ... Filename:="\\FinancialReporting\FY2006" ..., you might use
.... Filename:="\\FinancialReporting\FY" & range("B2").value ...
"bossman tv" wrote:
> I am trying to write a macro to save a excel spreadsheet and use a cell that
> contains text like a customer name.
...Forcing Outlook 2003 Not To Use Rich Text (WINMAIL.DAT)
I'm having a problem with my Outlook 2003 (which many others appear to
be having as well) whereby Outlook insists on sending some messages as
Outlook Rich Text Format, and of course non-Outlook recipients receive
a message with the infamous WINMAIL.DAT attachment.
I had imported my Contacts from Outlook 2000, and I believe that
somewhere during the export & import process, the Internet format for
the e-mail addresses of all my contacts (which you can view in the
E-mail Properties dialog box, by double-clicking a contact's e-mail
address) was set to "Send using Outl...Text colours printing wrong
(Publisher 2003 and Windows XP). I have just installed Office Professional
and am trying to use Publisher 2003. However the printed text colours do not
match the design colours at all making it totally useless! Fills and
pictures are ok. It is as if each font color is being translated to a new
colour. This is easily seen in Print Preview. Even when I us a supplied
template without modification this happens. Tried different colour schemes
with similar results. Example in the Nutmeg scheme a dark crimson prints as
a bright flame red and the khaki prints as bright yellow. If I convert to a
web pa...macro to find phone number and label with text
Here's the situation: I have long lists of satellite phone bills that
I need to track by individual phone users and I want to build a macro
that seeks out a specific number (example, macro searches "882 156 445
4554" and in the column next to it, automatically spits out "Dan's
In one Excel file, I have a growing list of satellite phone numbers
(~400 numbers) that I'm constantly adding to that I'm hoping the macro
can draw from. In the other set of files, I have individual phone
bills for each phone (about 18 separate excel files per month) wi...How do i use auto text to fill in a word after type few letters
i am trying to set my auto text to like at the end of a document , if i type
Sat... a screen tip will appear and display full Saturday?
There is no autocomplete function in Word 2007, like that you describe,
other than for dates.
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>