How to make return address labels in Publisher?
Can you do the title above in Publisher?
Sure. I've done them in different label sizes. What size labels are you
"Robert" <Robert@discussions.microsoft.com> wrote in message
> Can you do the title above in Publisher?
Thank you. I use the 2.5" x 1" size. it is a standard Avery Label size.
"Don Schmidt" wrote:
> Sure. I've done them in different label sizes. What size labels are you
> interested in?
> Van...Help with conditional formatting with 2000
Any help would be greatly appreciated.
I am trying to group data together into increments of 10% of th
numbers and then chart them based on these groups. For example, I hav
300 data points that vary from 20 to 500 in value. I want them t
appear in a chart based on the number of values that fall in the lowes
10% of numbers (ie. 20-40) then the next 10% (ie. 40-60) etc. up to th
top 10% of numbers, but I do not want to manually determine what thes
ranges are. I want to see a distribution of how many numbers fal
within each 10% of values.
I am not sure if this makes sense, please let me know...Date Formatting when Concantenating
I have a simple question. I have a cell that has date that looks lik
When I use the concantenate feature my date looks like this:
I tried to format the call every which way - but I cannot get it t
look the original.
Feeling really silly for even asking.. thanks all for your help
Message posted from http://www.ExcelForum.com
="Today is "&TEXT(TODAY(),"mm/dd/yyyy hh:mm")
Norman Harker MVP (Excel)
"bleu808 >" <<bleu808.189yij...1 Chart
I presently have an XY line chart showing asset price over time. Pretty
X Axis - Time Scale
Y Axis - Asset Price
I would now like to add an additoinal series showing the volume of
assets traded, ideally this would be as a bar chart sitting
"underneath" the asset price on the chart. They would share the same X
I have added another series, but this simply displays the volume traded
as another line, and even when this is set to a secondary axis the
scaling makes this unworkable. i have adjusted the scales of both,
still this does not make it workable, i want the series...Report Format
Env: CRM 3, VS 2003, remote connect to CRM server.
I've created a QUOTE in VS2003 and when viewed using PREVIEW from within the
VS environment it produces a beautiful QUOTE (at least in my opinion). When
printed, again from the VS environment, it is perfect. When I upload the RDL
file to the CRM server, create an new REPORT using this RDL then produce a
REPORT, the formatting is all over the place. When I inspect the source (in
VS) there are no fields that extend past the defined size. It appers that the
CRM report engine randomly adds CRLFs all thru the report ... ???
...How can I clear the last Data->Text to columns to formatting
I've noticed in Excel 2000 that if I paste text into various worksheets
within a workbook each paste will assume the Text->Column formatting that I
applied in the previous. How can I prevent it from happening ?
Just run another data|Text to columns against a dummy cell.
Specify delimited, but remove all the check marks from all the possible
(alternatively, you can close excel and reopen it.)
> I've noticed in Excel 2000 that if I paste text into various worksheets
> within a workbook each paste will assume the Text->Col...Percentage difference calc that knows the largest figure
I have a calculation in cell A3 which looks at the content of Cell A1 and
Cell A2 and then works out the difference between both as a percentage
Cell A1 = 100
Cell A2 = 10
Cell A3 returns the difference as being 90%
My simple calculation in Cell A3 is as follows =(A1-A2)/A1
Cell A3 is formatted to give the answer as a percentage to 2 decimal places
The above works fine as long as the number in Cell A1 is greater than the
number in Cell A2
If the number in A2 is greater than the number in A1 then my calculated
answer is incorrect
Cell A1 = 10...Conferting File format
One of my users stored 250 photos on CD in a pdf format. The person that will
work with them wants them in a raw format. Is there any way to convert the
entire disk at one time to a raw format, rather than opening each file and
saving in the new format? Thank you.
vsp deborah <email@example.com> was very recently
heard to utter:
> One of my users stored 250 photos on CD in a pdf format. The person
> that will work with them wants them in a raw format. Is there any way
> to convert the entire disk at one time to a raw format, rather than
> opening each f...Too many different cell formats #6
I am running into the error message:
Too many different cell formats
Is there a solution to lowering the number of formats I
am using? Just trying to change them to make some
consistent gives me the same error message.
I tried running the search on the forums on my topic but
they have been disabled for a Microsoft upgrade.
One idea -
Rob Bovey's excellent Utilities add-in will list all the formats in use in
your workbook, allowing you to manually delete what isn't being used.
You can also see the source code for ...How to get only the year in the date format in Access
How to get only the year in the date format
I.e in the table in need to display only year
E.g 2005 - should be display " 05" automatically
Custom format the cell as:
Please keep all correspondence within the NewsGroup, so all may benefit !
"yanu" <firstname.lastname@example.org> wrote in message
> How to get only the year in the date form...date/time formatting
I download a csv report from a web based program. Everything works great
but the date comes through as "Jul 21 2009 1:51pm". I do not need the time
in my report. I have tried reformatting the cells, tried to copy to a new
file with the cells already formatted to "7/21/09", opening the cell format
using the F2 key and deleting the time (time will still not be formatted
correctly). The only way I get get just the time is to retype every cell.
What am I doing wrong?
I am using Excel 2002 SP3
When data is downloaded from the web, a lot of "other&quo...format cell #4
In Access, I can set up a field that "forces" the user to enter info - a
date, for example - in a certain way, such as 25 Jan 05 or enter time as
12:15 AM. Is there a way that I can "force" this in excel?
Without invoking something more technical, you can select the cell(s) and go
to Data>Validation and choose what type of entry be allowed in the field.
Format the cell in the manner you wish to have the date or time expressed.
> In Access, I can set up a field that "forces" the user to enter in...unicode format files for Outlook 2002
I use Outlook 2002. I would like to use Unicode files (for larger size). I
see references to using it with Outlook 2003, but none for 2002. can
unicode files be used with Outlook 2002? If so, how?
OL 2003 & 2007 only
"Huck Rorick" <email@example.com> wrote in message
>I use Outlook 2002. I would like to use Unicode files (for larger size).
>I see references to using it with Outlook 2003, but none for 2002. can
>unicode files be used with Outlook 2002? If so, how?
> than...Formatting cells and getting pound signs
I am using Excel 2003 with all updates as of 4/28/04 and trying to format a cell using the custom category and choosing the #,##0.00 type.
I am trying to add the $ symbol at the beginning of the type and add text at the end of the type to look like this $#,##0.00 "text".
When I do this however it shows up in my cell on my worksheet as ##########. It does know what the value is and shows as I would expect it to when I place mouse over cell in a balloon
If I use only the $ symbol befor the type it shows fine. If I use only the "text" after the type is shows fine. Using the...Does anyone have a format or template for a Education Cover Letter
Does anyone have a format or template for a Education Cover Letter?
To Whom It May Concern:
Enclosed please find an education.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"eb" <firstname.lastname@example.org> wrote in message
> Does anyone have a format or template for a Education Cover Letter?
"Suzanne S. Barnhill" <email@example.com> wrote in message
news:O3aNFsq2KHA.5212@TK2MSFTNGP04.phx.g...Selecting cell value for a sum, based on a condition
Trying to come up with a formula or method that will enable me to sum values
based on a condition. For example, I have three columns which contain a
condition and two amounts. If the condition is of the 'each' variety, one value
will be used in the sum. If the condition is of the "square foot" variety,
another value will be used. Here is a small diagram that may help visualize
A B C D
1 Measure Unit Cost S.F. Cost Summed Total
2 Each 3.00 .30
3 S.F....Conditional Formatting on cells beginning with a hyphen
Is it possible to do conditional formatting on cells beginning with a
1. Place the cursor in A1 cell and select the Range
2. From menu Format>Conditional Formatting>
3. For Condition1>Select 'Formula Is' and paste the below formula
4. Click Format Button>Font>Color select your desired font & Background
Color pattern and then give ok
Change the cell reference of A1 to your desired cell, if required.
But keep in mind that when applying the conditional formatting the Active
cell should be in the ce...time formats #3
I have an Excel sheet with a long list of times spent on various projects.
The times should all be in minutes and seconds. The first time reads 2:29
and I know that is accurate, for 2 min, 29 seconds. In the formula bar, it
reads, 2:29:00 AM. Another...the cell displays 0:40 and I know that is
right, for 40 seconds. But in the formula bar, I see 12:40:00 AM
I want numbers, but apparently I am looking at times.
I tried changing the format. When I check the format for 2:29, it comes up
Custom and says it is hh:mm, not mm:ss. I tried changing it to mm:ss, but
that changes the displa...an attempt was made to load a program with an incorrect format
This is the error I get on Windows 7.
I tried going to the project screen in vb.net Studio 2008, and changing the
target cpu to x64. This did not work.
Do I have to build the program on Windows 7?
I'm sure this must be a common problem for programs going to Windows 7.
Thanks for any help.
On May 22, 2:17=A0am, "Scott Baxter" <sc...@websearchstore.com> wrote:
> This is the error I get on Windows 7.
> I tried going to the project screen in vb.net Studio 2008, and changing t=
> target cpu to x64....Error trying to make an account default
I have a new computer and my outlook 2003 is not letting
me assign a default account to send and receive. I get
this error: "The Specicied Account could not be found. It
might have been deleted."
I have four accounnts setup and have tried removing the
accounts and recreating them and still get the error.
when the account has been made, it tests fine. None of
the four can be made default.
Thanks in Advance!
...Excel Number Format Codes
I can't figure out how to format numbers so that when you type 3220 it will look like 32.20 kinda like how you can enter numbers on an adding machine. I would greatly appreciate this number format code. Thank you.
I think you want to go Tools | Options | Edit | Fixed Decimals - 2.
That will divide all the numbers you enter by 100.
You will also have to format the row or column to display 2 decimals.
Select the cells or range, right mouse click, format cells, numbers, 2
Hope that helps.
"MBB" <MBB@discussions.microsoft.com> w...EXTRACTING UNIQUE RECORD BASED ON CONDITION
This is a multi-part message in MIME format.
I would like to extract unique records based on a condition. For =
example, how to extract unique record from column 'B' when column 'A' =
has "AP" or any other desired condition.
The data is as follows:
A B =20
AP PATRICK CUDAHY INCORPORATED=20
AP PATRICK CUDAHY INCORPORATED=20
AP SUGAR CREEK ...Users cannot login to OWA after Exchange 2K3 was moved into different OU
I created a new OU named member servers, and moved the
exchange 2k3 server into it. After I moved it, only the
administrator was able to login to OWA successfully. No
users could login to OWA. I created a test account with a
mailbox, and was able to login to OWA with the newly
created test account. I then moved the exchange 2k3
server from the member servers OU into the computers OU,
and the newly created account was unable to login to OWA.
Any help with this would be appreciated.
...Save custom formats independantly of workbooks?
Is there a way to save several custom formats (say,
numbers in $000's, in $ millions, etc) which I would use
for a variety of workbooks (including workbooks where
those formats do not exist yet), with a name, and make
them accessible from the toolbars?
Earlier today someone kindly suggested to assign a name
to the format using Format -> Style, but the formats I
had saved have disappeared from the style menu once I
closed a spreadhseet and used a different one. Any
...Moving certain data to different sheet
I need to move data that meets a certain criteria, to another sheet within a
workbook. For instance, if a column of data is for a certain ZIP code area, I
need it to automatically copy to a sheet for that city. Say, 40202 would go
to the Louisville, KY sheet. Because Louisville has multiple ZIPs, I would
need only the data that begins with 402 to go to that sheet. Lexington KY's
data, which begins with ZIP code 405, would go to its own sheet. Macro?
This can definitely not be created with a formula. I suggest that you make
use of the macros.