How do I extract text content from an exported .rwz file
Outlook 2003, Office Pro -
When you export Rules and create a .rwz file, the file is not a pure text
file as it seems to be loaded with null chars. I would like to extract the
long list of spam words used in a particular rule. Is there a way or a
utility which will remove all the nulls from the file so I may edit it to
get the contents I want ?
The alternative storage location is not any easier - trying to get the same
info, as it is similarly stored, out of the registry. :(
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-Backup and R...background image formatting
How can I make a background image stretched instead of tiled?
I am using a default picture in publisher of clouds and they of course don't
look right being tiled.
Thanks a lot
Resize the image?
If you're asking about web bg's, you can but the result is u g l y
Microsoft MVP - FrontPage
"David" <David@discussions.microsoft.com> wrote in message
| Hi All,
| How can I make a background image stretched instead of tiled?
| I am using a default picture in publisher ...change control source or value of text box
I have a report with GroupHeader0 and GroupHeader1. The data source of the
report is a query. In the GroupHeader0 I have the Purchase Order Header info
which includes the Purchase Order due date. In the GroupHeader1 I have the
Purchase Order line info which includes the line due date. What I need is if
the line due date is Null or blank to default to the PO header due date. How
can I assign the header due date to the line due date. Can I change the
control source of the text box in VB programming.
Put the following expression in the first blank field in your query:
i have a spreadsheet that i backup & copy to a new folder but the cell
formulas are replaced with the cell values. how do i keep the formula
Save two copies???
One with the formulas and one after the formulas have been converted to values.
> i have a spreadsheet that i backup & copy to a new folder but the cell
> formulas are replaced with the cell values. how do i keep the formula
Or are you saying that when you make the backup copy the formulas are somehow
changed to values...Preserving Cell Formats in Excel Query
I am doing queries on a large workbook of multiple Excel spreadsheets. When I query the data, the original data formats don't carry through to the query results. Is there a way to carry original formatting through to Excel Query results
Any insight would be appreciated
No, you can import the data, but not the formats. If you're importing
programmatically, you could apply the formatting as part of the import
Karen S wrote:
> I am doing queries on a large workbook of multiple Excel spreadsheets. When I query the data, the original data formats don't car...Formula result shows as zero Excel 2003
Formula as shown =IF(C12<>"",+C11-C12,"") appears in D12. This is the same
formula as rows above but rows above show correct result whereas D12 and
subsequent rows show only zero.
If I do an F2 and F9, the correct result shows in the Formula Editing bar so
formula is working correctly. I have tried copying both formula and cell
formatting from previous rows which do display their result correctly but
still doesn't fix the problem.
Any assistance would be much appreciated
maybe automatic calculation is disabled. Check 'Tools - Options -
Calculate...Format cells with dates
Is there a way to format cells so that dates would change when the lead date is changed. for example, when I input monday's date, tue, wed, thur, etc will follow suit.
Assuming the first date is in A1
C1: =B 1+1
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Pat" <email@example.com> wrote in message
> Is there a way to format cells so that dates would change when the lead
date is...Conditional Formula based on previous date + 30
I have a spread sheet that caluclates when proposals expire.
Date Sent Follow Up date
January 13, 2010 February 12, 2010
What I am looking for is for the Follow up date to turn RED when the date is
expired (over the date listed).
Just use CF with a formula of
"Chris" <Chris@discussions.microsoft.com> wrote in message
>I have a spread sheet that calu...paste-linking annotating text boxes
I'm trying to insert an Excel chart into a PowerPoint
presentation and link it dynamically. The data link is
not an issue but I cannot find a practical way to paste
the text boxes that were added to the Excel chart by way
Selecting and pasting the chart itself and the textboxes
as if they were separate objects results in a distorted
PowerPoint layout. Is my only choice to add the text
boxes anew in PowerPoint?
Select the chart prior to adding the textbox. The textbox then will be
part of the chart, rather than just another drawing object floating
above the worksh...Display Field Name as Text Listing if Value True from Checkbox Fields
I have 40 or so columns in a table using the yes/no data type. Each
record in the table represents an audit of a paper form. Those items
filled incorrectly or incompletely on the paper form receive a check
on an access form during the audit process.
I would like to create a feedback form based on the audit record that
displays a listing of fields that received the check boxes, or rather,
were incomplete or incorrect on paper form that was audited.
On the feedback form, I only want to display something like this:
"Your form had the following errors:
Erro...Conditional Formating Help
I wonder if anyone could help me, I am after code for the following.
cell e6 = Keys Sent
Column f6 = Keys due
Column g6 = Keys received
What I want the script to do is if there is no value in g6 and todays date
is greater then the date stated in F6, then the cell turns red (prompt to
inform me that keys are late).
Use a CF formula of
"housinglad" <firstname.lastname@example.org> wrote in message
...Conditional Formating Furmula
I have to enter a 14 digit licence number in a field this is a mix of numbers
and leters. can some one please give me a formula that i can use in
conditional formating tol show if there are to few or to many digits. (Using
excel 2003) Thaks in advance.
CF/ Formula is/ =LEN(A1)<14
Format as desired for too few
CF/ Formula is/ =LEN(A1)>14
Format as desired for too many
Rather than using CF you could, of course, use Data validation to require
LEN(A1) to be 14.
"jockj215" <email@example.com> wrote in message
news:A24...Tricky Formula.. Please Help
I have created a time roster.. easy
in each day I have start,end and break deduction.. still no probs
I need to create an output formula for hours worked after a 16:00 from
the start and end range on a day. So in the roster it will still display
normal hours, however I will create a field for hours after 16:00. this
is for calculating a different wage rate.
See response in .programming
(remove nothere from the email address if mailing direct)
"Aaron H" <firstname.lastname@example.org> wrote in message
...Match formula to match values in multiple columns
Hi all, does any friend know that how can I make below formula work
I am not sure I have understood correectly. Please go through the below example
With data as below if you need to retrive the name of the 1st Rank holder
D2 = 1
D3 = London
In D4 apply the below formula
Please note that this is an array formula. You create array formulas in the
same way that you create other formulas, except you press CTRL+SHIFT+ENTER to
enter the formula. If successful in 'Formula Bar'...Conditional Formatting
I need help on conditional Formatting.
I have a column of data with future DATE, such as 2 Jan 09, 4 Des 09, etc
I would like to assign automatically different colors to those data that
match these condition:
If (TODAY's date < Data's date) And more than 30 days, COLOUR is Orange
If (TODAY's date < Data's date) And more than 60 days, COLOUR is Yellow
If (TODAY's date < Data's date) And more than 90 days, COLOUR is Green
If (TODAY's date >= Data's date) And more than 30 days, COLOUR is Red
I would like to gave it AUTO...Blurry text in Bold
Bold characters in excel cells are blurred (reduced clarity) regular text appears fine.
Please advise on remedy
I understand that Word 2003 has similar issues on regular font. (deactivate ClearType was solution for word)
I cannot find any info regarding Excel 2003 in knowledge base
...How do you copy a cell's content verses it's formula?
I have 2 cells and combined them into a third cell with the following
formula... =a1&" "&b1. I was combining a person's first name (cell 1) with a
person's second name (cell 2) so cell 3 included the first and second name.
Now I want to copy and paste cell 3, but it copies the formula... I need to
paste in the content (first and second name) not the formula.
You could use a macro see JOIN macro on it's page
not what you actually asked because if would change
column A with the concatenated const...Question about formula or marco
Here is what I need to do:
Column B will have a list of first names (John), Column C will have last
What kind of formula or macro do I need so that I can have Column A read
"jsmith" (all lower case)?
Thanks very much.
Try this formula in Cell A1:-
"Gus Jae" <email@example.com> wrote in message
> Hi all,
> Here is what I need to do:
> Column B will have a list of first names (John), Column C will have last
> names (Smith).
> What kind of formu...Import plain text with formulas into Excel
I'm having some trouble in Excel. If I create a plain text file like the
Nothing can be done as if in spanish is (SI), iserror is (ESERROR), and
so on. This really sucks as I can't just install other software on the
server nor make other modifications.
I don't know what Microsoft was thinking when they translated the
versions; any Excel version should accept it's language commands and
English commands, but well, that's too much to ask for...
Any good sugestions?
Anyone ever seen this before?
This was what happened to a mac excel spreadsheet the user doesnt know how
she did this but i wondered if anyone might recognize this current format.
In hopes we can change it back. Formatting is below.
thx for any help ... Ed
AGwAFgAAPz8/Pz8/Pz8B...Text fields in report writer
I have a modified report dictionary, when I go into a report layout and enter
a text field, when I tab off the field what I wrote is converted to something
totally different. Has anyone seen this before? Reports that I have been
using for months suddenly the text fields print something totally different.
????? Any suggestions would be helpful. Thank you!
We use a shared dictionary located on our server, and I find text fields do
not "travel" well - ie. I often lose info if I export a report out of the
dictionary to work on it.
What I do is make a copy of the enti...Formatting hyperlinks in an Excel cell 02-16-10
Two of the columns in a spreadsheet (Excel 2003) that I use record email and
All of them appear as hyperlinks i.e. blue and underlined but some
occasionally seem to lose their hyperlink properties. This means that when
one hovers over them, the cursor stays as the usual Excel cross rather than
changing to the hand/finger symbol. Also, clicking on the former does not
launch the browser.
Is there any way to ensure they are formatted, and work, as hyperlinks
...Formatting date fields after export
I am experiencing problems with my exported date fields into Excel from other
applications. The data formats to "yyyy-mm-dd" and cannot be modified unless
I double-click on each field. Has anyone else experienced this problem? And
what solutions would you suggest?
It is probably seen as text,
select the imported dates, do data>text to columns,
click next twice, under column data format select date and YMD
> I am experiencing problems with my exported date fields into Excel from other
> applications. The d...Formula auditing on protected sheets
Simple question: is there a easy (or difficult?) way to track precedent and
dependent cells on sheets which are protected?
...Parse multiple text lines into 1 line in excel
help. I am an excel beginner and can't find out how to turn multipl
lines of text into 1 row in excel. It's probably really easy but m
manual is USELESS. Can anyone help
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
You're a little short on details. If nothing below fits the bill post back.
"Multiple lines" is how many and is each line in a separate cell down one
Do you want all lines to go into one cell?
You can use this form...