Stagger X-axis text
In 1-2-3 I could stagger the text in the X-axis. In Excel it seems
that I can only rotate the text to 90 degrees.
Is there a way to stagger and leave horizontal?
Specifically, I have all the provinces (or 10 of them) across the axis
and they take up room when spelt out (no abbreviations allowed). I
would rather the first, third, fifth ... etc. be higher and the
second, fourth etc. be lower to allow the chart to be narrower and
still read the text clearly.
>In 1-2-3 I could stagger the text in the X-axis. In Excel
I would...Outlook 2003
Is there a way to force all incoming email to be received as plain text in
How about: "Tools | Options | E-Mail Options | Read all standard mail in
Ben M. Schorr, OneNote-MVP
Stockholm Consulting Group/KSG
Microsoft OneNote FAQ:
**I apologize but I am unable to respond to direct requests for assistance.
Please post questions and replies here in the newsgroup. Mahalo!
"Howard Cross" <no-spam@No-Spam.com> wrote in message
...How do I get excel to accept (c) as text and not change to copyri.
How do I enter the text (c) in Excel without having it changed into the
Tools | Autocorrect | Select (c) | Delete | OK
"daffyd" <email@example.com> wrote in message
> How do I enter the text (c) in Excel without having it changed into the
> copyright symbol?
Go into the Tools Menu. Look for AutoCorrect. In the bottom half of the
AutoCorrect Tab, look at the list for Replace text as you type. Delete the
entry for (c).
"da...To write living will do I need special format
I just need to change and update a living trust
You should consult someone with the appropriate legal knowledge in the
jurisdiction in which you are domiciled.
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"belladonna" <firstname.lastname@example.org> wrote in message
> I just need to change and update a living trust
...Numbers in a text field-can I add them up?
Hi everyone! Using A02 on XP.
I have a table of data with survey response fields that contain a 0,1,2,3,4
or 5. However, the fields are formatted as text, not numbers. I need to add
up certain blocks (Items 1-6, Items 7-23, etc.) and then do some averaging.
I cannot change the field types from text. Must I append to a new table or
can I do something right in my query?
I've got one field in my query like this: ES:
My result is: 553453 or 554444, etc. I want: 25 or 22, etc.
I would really appreciate any help or advice. Thanks...How do I set the number format to Base 12?
I would like to change the number format on my spreadsheet from Base 10 to
Base 12, eg. 12 bottles makes up 1 case. Therefore, if I were adding up three
different cells 9 bottles + 11 bottles + 6 bottles, my result should be 2
cases 2 bottles if possible 2.2 in a case column.
See http://www.cpearson.com/excel/fractional.htm for details.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Andrew Moore" <AndrewMoore@discussions.microsoft.com> wrote in
>...Help ! formatting data to text
I am creating data in an Excel spreadsheet. I then want to get that data
into a simple text email. I have some problems and questions...
1) how do I get the columns of data to line up evenly when I copy the data
to email text ? Keep in mind I need to be in simple text format, not HTML
or rich text.
Every time I do this, all columns become chaos and are unreadable.
2) Is there a simple way to automate the creation of an email from an excel
file ? this is less important to me.
Thanks in advance
#1. I think it may have to do with what email client you use, too.
I copy and ...Conditional Formatting w/ a List/Icons
I am trying to allow someone to select "Green", "Yellow" or "Red" from a list
and the cell to display a green/yellow/red icon appropriately. Or, if
possible, the user could just select the icon (instead of selecting text).
Is this possible?
Use Data Validation for the list. Type in Red, Yellow, Green as the list.
This give the user the list to select from.
Use Conditional Formatting for the fill part. Set three conditions, If Cell
Value-"Green" (select a green fill), etc..
If this helps, please remember to click yes.
"...VISIO 2007 -Text direction
can some one tell me how to change text to be type in vertically. Under
tools, options there is no regional tab or under format text the change text
direction command does not work.
"kgbrat" <email@example.com> wrote in message
> can some one tell me how to change text to be type in vertically. Under
> tools, options there is no regional tab or under format text the change
> direction command does not work.
You can use the Text Tool (The A with an circular arrow around it) and gr...Hot Dates
I have a Year-at-a-Glance worksheet into which users enter important dates
and associated actions to be taken. I now want to use Conditional
Formatting to highlight specific entries in the worksheet when their date
matches today's date.
The problem I have is that I need to convert data from three independent
cells into a date to compare it with 'TODAY()'.
The first cell (formatted as a number) carries the day, e.g. 2, 17, 23,
The second cell (formatted as General) carries the month, e.g. January,
March, September, etc.
The third cell (formatted as a num...conditional format 04-15-10
I want the color of the text in cell B1 to change depending on the value
in cell A1
How can this be done?
I know I can do it with conditionale format for the cell itself but not
for another one.
Try this. Assume you want B1 text to change colour when the value in A1 is 5,
select B1 and go to conditional formatting. In the condition, select 'Formula
is' then in the empty space, type =A1=5 choose the font colour that you want.
> I want the color of the text in cell B1 to change depending on th...Special format
How can I change the format from numerical to English??
e.g.: 420 to Four Hundred and Twenty Only
It is called typing - UNBELIEVABLE
or SEARCH and REPLACE
but MS Office 2002 Chin support numerical to chinese:
123456789 -----> =
=3D.=3D" Can anyone help~~
>It is called typing - UNBELIEVABLE
>or SEARCH and REPLACE
...Insert Static Date as part of Macro
I've built a nice macro, but I want it to insert the date it is run in an
empty cell within the macro's range. When working within a spreadsheet, Ctrl
+; returns the system date, but I can't figure out how to put that command
into a macro.
The macro recorder editor shows that the system recognizes the entry as the
current date, not a function that returns the current date.
The now() or today() functions are both dynamic ... they change with the
system date. That's not acceptable in this situation. I need to seen when
the macro was run.
Thanks for any help,
di...reply formatting in Outlook 2010
I set up my normal.email.dotm file to have 12 pts below each
paragraph, which helps formatting issues when sending emails to people
using gmail and other programs that interpret paragraph breaks
differently than Outlook.
That works just fine with new emails. However, when I reply to an
email, even an html email, the formatting is not applied. I can fix
this by choosing Format Text and then setting the spacing as per
above, but this is a pain in the neck.
Why don't reply emails use the same template? Is there a way to
template replies so i can use the same formatting?
thanks in advance,
...How can I keep track of when (date and time) data is entered into.
I am trying to create a spreadsheet for a high school class. I need to be
able to track when a student has entered data into specific cells of the
spreadsheet. Any ideas?
In the code behind the worksheet, enter (eg)
Private Sub Worksheet_Change(ByVal Target As Range)
Cells(1, 1).Value = Now()
This will enter in Cell A1 the date and time at which any entry is made in
If you need the location of the time-stamp to vary according to which cell
is changed then you can test the value of Target and vary the destination
Return email address is n...zz report date truncation
We run only z reports at end of day. We will be running cashier shifts soon
and would like to run z and zz reports the way they were intended. Is there
any way to truncate the zz report date for each register without it running
since the beginning of time and using a truckload of paper?
Thanks in advance!
This may not be the most graceful solution, but you could simply turn off
your printer before 'printing' the zz report. Then manually delete all print
tasks for that printer before turning it back on. The report won't print,
but RMS will think it did.
"TV hardwa...How can I cut data out of HTML table, into msExcel and just take the data & columns? (but NOT the formatting & URLs!)
This is driving me ABSOLUTELY NUTS!
How can I keep the rows & columns of data that I am copying and pasting
off a website (my own in this case!), into a spreadsheet... WITHOUT
taking all the data formatting?
If I paste out of Ms IE v6 into Ms Excel (2003), it does at least keep
columns (something that doesnt happen if I paste out of FireFox, fwiw).
But it pastes with all the formatting & URLs etc - which I DONT WANT!
OK, I can save as .CSV, close, 2 warnings, and re-open but when done
REPEATEDLY this is a damned nuicance!
ship w...Exchange 2K: Controlling incoming email formats....
AFAIK (and correct me if I am wrong), Exchange natively only lets you
control message formats for messages that are downloaded to POP\IMAP
For security reasons, I would like Exchange to convert all incoming\outgoing
email from\to external domains, as well as INTRA-domain email , to plain
text format. In other words, I do not want to see anymore html email on my
server going in and out, just plain text.
Is there a setting for this for Exchange to handle this natively? If not,
what (if any) 3rd party solutions are out there for this?
Here's the Re...Text in column causing SUMPRODUCT error
Greegings. I have a SUMPRODUCT formula that is having errors when one of the
columns has text instead of a NULL or a number. If I delete the text cells
in that column it works as desired. I'll give a simple example. Suppose I
have the following in A1:B6....
And I need this...
It errors out until I delete the "abc" in cell B3, then it works as desired.
I tried to replace the "abc" with a 0 by trying this...
And it works for that pa...Historical IV Trial Balance
When running this report in Summary, I am receiving an error when trying to
run with a date range. Has anyone seen this before?
are you getting a duplicate error? If you are, then what you are experiencing
is a bug. To fix, you will have to apply the latest service pack.
Hope this helps.
> When running this report in Summary, I am receiving an error when trying to
> run with a date range. Has anyone seen this before?
I think so. I'll try that by applying SP 4 for 10.0
> are you gettin...Copy cell contents, then paste into the same cell with other text.
I tried a search first and couldn't find anything like this. My spreadsheet
has a column for shipping that takes a series like this for each product:
Following the question mark is the handling charge (0.0 in this example).
This is followed by an * and then the weight of the item (0.13.2 in this
example which is 13.2 ounces)
I have a list of product weights in a colum with just pounds and ounces. I
need to copy that information, then paste it into the weight area of the
string above and then paste those modified contents back into t...Excel
I would like to know if there is a way to set up when I enter the data
each cells on first row, it will default the date and time stamp on
first row. 2nd row should have the different date and time stamp than
I put "=now()" but it create the same date and time for 80 rows. I
don't want that. I want to enter each rows and each rows should be
different by one minute apart but same date - June 22.
Your help would be much appreciated.
Format A1:A79 as Custom dd-mmm-yy h:mm
Hold down CTRL Key and hit semi-colon key then <space> bar.
Sti...Formatting in the formula bar
When i type in a number into a cell in my worksheet, say:
Excel automatically rounds it to 43. Which is what i want and what i set it
up to do.
However, the number in the formula bar also rounds to 43.
Normally i thought the formula bar stayed at 42.99 and only the spreadsheet
cell rounds to 43.
I am using Excel 2000.
Please help asap as i need the formula bar to stay at 42.99 so i remember
what the original number was!!!
maybe you have checked 'Tools - Options - Calculation - Precision as
> When ...Help replacing text with Yes or No
I have a field formated as general. The field contains either 1 or is left
blank. If the field has a 1 I want to replace it with Yes and if the field
is blank I want to replace it with No.
any help is appreciated.
Save your data and use a copy for this exercize...........
Assuming your data in Column A, put this in B1 and copy down........
Then highlight the column and do Copy > PasteSpecial > Values to get rid of
the formulas..........then delete column A if you wish.......
Vaya con Dios,
"Jerry Arnone, ...Date changing 2028....2029......1930???????
I have a slight problem, in my form i have a date section which is automated
as 00/00/00. I use these for part of a report as a from this date to this
date, if you put 010125 it will automatically change it to 01/01/2025. The
thing I have found is that it is fine until you get to 010130 and then it
saves it as 01/01/1930 :-/ any ideas?
Message posted via AccessMonster.com
Assuming you're using XP, go to Regional Settings in the Control Panel, and
click on the Customize button. Look on the...