Feb 28,2008 ---> 2008-2-28
Feb 1,2008 ---> 2008-2-1
"����" <email@example.com> wrote in message
> Feb 28,2008 ---> 2008-2-28
> Feb 1,2008 ---> 2008-2-1
See your other post
> Feb 28,2008 ---> 2008-2-28
> Feb 1,2008 ---> 2008-2-1
Highlight the cell, right click in the mouse, cell format, custom format and
> Fe...Find and replace 03-04-10
I'm trying to scan a field in one of my tables and find a specific character
and remove it. However, the character is a " so I'm having difficulty. The
field I speak of of contains the sizes of our material so the values look
1/3" and so on.
How can I find all of the " in my feild and remove them? I don't want to
replace them I just want to remove them.
Create a query, and in the Criteria row under the problem field, enter:
Allen Browne - ...formating (000)
Is there any way I can format numbers so only thousands
100,000 I'd like to show 100
1,000,000 I'd like to show 1,000
(I can just specify in the column heading that all
numbers are (000).)
Is this done using custom formats? Going through and
dividing by 100 seems like a pain.
try the custom format
> Is there any way I can format numbers so only thousands
> Instead of:
> 100,000 I'd like to show 100
> 1,000,000 I'd like to show 1,000
> (I can ...Formula needed 01-22-10
I need a formula that will look in one column range for a certain value and
for another value in another column range and when they are both found in the
same row, will count the number of occurances. Help!!!!
> I need a formula that will look in one column range for a certain value and
> for another value in another column range and when they are both found in the
> same row, will count the number of occurances. Help!!!!
Omit the "values to be summed".
=SUMPRODUCT(--(A2...HELP WITH FORMULA #15
I have 3 columns.
These columns are continuous and I keep adding amounts to cells in column C
and deducting amounts from I column and need to end up with a total in
Could someone please help me with a formula that will continually give me a
total to column J as I enter information into column C and deducting from
Thank you in advance for your assistance
Adjust range of cells to your need.......
Vaya con Dios,
"Hank Laskin" wrote:
> I have 3 columns.
> C -I=J
> These columns are continuous and I ...Subject based filtering of DSN messages
I can't make this work for the vast majority of the DSN messages we get
(message undeliverable and such). I have setup rules to filter the different
bounce messages that I see in subject lines and some of them work fine.
Most do not.
The messages the come from postfix (for instance) have mime-encoded
notification messages, split in several parts.
I've tried matching the Subject: line I end up seeing in Outlook and the
subject line that is in the internet headers of the message, which is not
what outlook shows me. I think exchange 2003 is recognizing these messages
and try...M2004: Change name on home page?
I'm using Money 2004. On the home page it says "So-and-so's Money Home
Page". How can I change the name that appears there?
> I'm using Money 2004. On the home page it says "So-and-so's Money Home
> Page". How can I change the name that appears there?
Figures... I always seem to find a solution right after posting a
question! Click Accounts & Bills, Account Setup, Update Personal
...Mysterious Retained Earnings account
Other than the obvious GL table, where else would one assign account
numbers? My GL table DOES NOT have my Quickbooks retained earnings
account number ANYWHERE in it; however, RMS continues to post to that
account. WHY WHY WHY? Where could it be?
This is a multi-part message in MIME format.
IANAA, but from Help;
This section describes how to export General Ledger (GL) accounting data =
from Store Operations to a file, and ...SendTo PDF Not Working on GP 10
I upgraded a client from GP 8.0 to GP 10.0. Since the ugprade, they are
unable to use the SendTo PDF option from within GP. We have tried
reinstalling Adobe and that hasn't changed anything. The users can see the
PDF being created but a blank email doesn't open from their email client as
it used to. The client is on version 10.00.0991 and I thought this issue was
to be resolved in 10.0 SP 1 but obviously it hasn't been for us. The client
is also using Outlook. Is this still a bug with 10.0 or are we missing
I am on Adobe Acrobat Standard 8.0 with Microsoft ...Home Page Content Item: Important Dates (repost)
I asked this question 3 days ago and have received no replies so I'm
repeating it. Perhaps the subject name I used: "Important Dates" was too
short or sounded like spam. In any case my experience on this board is that
even if no one has a solution, someone usually responds saying that he can't
reproduce the problem, or that it doesn't work for him either, or that the
poster misunderstands what this function is supposed to do. Not having
received any response at all, I beg your indulgence with this repost:
Money 2006. No Passport. XP Home SP2. P4 3.0 GHz. 1G...Lost contact list 04-22-10
I amusing Windows live mail...it had no problem picking up my contacts from
Now that I syncronized messages from my Hotmail e-mail account and my Telus
email account into Windows Live, my contact list is only the two contacts
from the hotmail account. All the rest are gone. They are still in the
Address Book, but I cant access them
How can I get it back into Windows Live Mail ??? Help please.
You signed into the Hotmail account when you started Windows Live Mail.
This is optional and not at all related to getting your mail.
When you sign in, WLM sync...Paycode to be nontax upto a certain $ and taxed after certain $
Not sure if this can be done in GP 10 Payroll, but is there a way to set-up
a pay code that is non-taxable up to say $5000.00 but once the paycode
reaches $5000.00 paid out to the employee it can be changed to be taxable?
Do we have to set-up 2 paycodes and track it on our own or can we have GP
Thanks in advance
You will have to create two pay codes and and track the amounts separately.
You can set up a business alert to let you know when an employee has hit
$5,000. If you have SmartList Builder, you could create a SmartList and then
use it as a Reminder.
...Outlook 2003 03-17-10
1. Process will complete mailing address to sent item means anything ?
2. Repairmail up screen time that does not match the running because of what ?
3. The move affects the computer to send mail or receive ?
On 3/16/2010 8:19 PM, supatsiri wrote:
> Dear Sir,
> 1. Process will complete mailing address to sent item means anything ?
> 2. Repairmail up screen time that does not match the running because of what ?
> 3. The move affects the computer to send mail or receive ?
> Best Regards,
What is your native language? Please post ...cell to have comma-delimited values based on text
I have a table called "220_reference" with a column name "Part Number" having
a sample value of below:
4047122(All Dash no.), 4057222(All Dash no.), 4058222(All Dash no.),
4060122(All Dash no.)
The entire value is in one cell representing the "Part Number"
column(defined as general type so text I suppose).
Simple enough. But what I need to do is take any number that has "(All Dash
no.)" after it and search through a column in another table to retrieve any
rows that have that number(text) in it. The other table name is "220" with ...Home Loan with Extra Principal
I currently have my Morgage withdrawn directly from my
checking account. I want to post it into the register
automatically but not have it double post when I download
my transactions from my checking account.
Also, when I setup my loan through Money automated system
it determines my loan payment of (not real numbers)
$1050.00 with P+I+Taxes+Insurance.
I currently have $1100.00 withdrawn from my account with
the extra $50.00 going towards principal. How can I
reflect this extra $50.00 towards princial in Money.
Currently when I go to Account List and Home Loan is only
shows $1050....disappearing e-mail 04-21-10
This has happenend several times: Vista; When I open my e-mail, some email
just disappears, it's not in any folder, it's just gone. I''ve read other
threads that say make sure you are are set to show all messages and I am.
"Trish1856" <firstname.lastname@example.org> wrote in message
> This has happenend several times: Vista; When I open my e-mail, some
> just disappears, it's not in any folder, it's just gone. I''ve read other
> threads that say make...Receive PO based on amount.
Greetings GPLings.. :)
Is there any way to receive with invoice , a PO that contain service /non
inventoried items based on the amount?
Eg: PO amount $100000000 for ONE service item and i would want to receive
and invoice only $ 200.
The reason i used this huge amount as PO is that even if i used a decimal
value to receive the PO as a percentage,it will still not be accurate as GP
allows only 5 decimal places.
In a simple form, i want to receive based on the amount rather than qty.
The only way to do that is to enter the PO for a quantity of
100,000,000 at a unit...Mail Merge 03-12-10
I have a log that has multiple lines with the same individual that I am
trying to merge into one page per individual in word, I have to do a more
advanced mail merge.
Assuming you are using Word for the mailmerge and Excel for the source see
these sites for help.
Gord Dibben MS Excel MVP
On Fri, 12 Mar 2010 08:33:01 -0800, Brooke
>I have a...Dynamics GP 10 Reporting Question
I heard reporting in GP 10 is upgraded. Does anyone know if it will be
anything like Rockton Software Dynamics Report Manager where you can send any
report to like Sql reporting services or crystal?
I haven't heard anything at all that reporting in 10.0 will be changed.
While I guess it's possible, I would assume for now that there won't be any
big changes in general. I would expect more MS Office & SQL integration in
the next version for sure, but I can't see everything rewrit...Home based Job For Indian
Want the pleasure of life, don't worry, work 1-2hours/day and earn Rs.
10,000-15,000/month online from your home/cafe/office
For details write # email@example.com
Please write the subject of mail as: "Job Inquiry"
...sum items in a table based on description
I am interested in summing items is a table based on their description. Is
there a formula that will add items together from column based on the
contents in another cell reference in the same row? I know a pivot table
will do this with some restrictions in the table design.
You can use sumif if there is onbly one condition
Assume you want to sum values in column
C where column B is "x"
"Hrider" <firstname.lastname@example.org> wrote in message
>I am interested ...Fast alternative to table based state transition matrix
I got this answer from comp.theory. It was completely obvious once it
was explained. It is trivially simple to create a DFA based recognizer
without a state transition matrix data table. Simply encode case
statements corresponding to inputs within the case elements of a case
statement corresponding to states.
In at least some cases the (case within case) method might be faster
depending upon whether or not memory is reduced enough to more than
offset the higher case statement overhead to increase cache locality of
"Peter Olcott" <NoSpam@OCR4Screen.com...Join based on next closest value (like Excel VLOOKUP)
Trying to do something similar to a VLOOKUP (Excel) in an Access 2003 query.
I have the following tables:
I need a query that takes JOBS.Quantity, looks it up in COSTS.Quantity and
find the cost for the NEXT LOWEST quantity. (Example: Job B has a quantity
of 256 and the next LOWEST quantity from COSTS is 200 so Job B costs $1500.)
The results should be as follows:
This would be ...Colouring Emails based on Headers
I am trying to use colour to pick out spam identified by a Spam program in
I have gone into the advanced settings, but can't seem to find an option to
colour based on content of the headers.
Can anyone help me out here?
Take a look at HeaderToCategory for MS Exchange 2000/2003 application:
It could help in that case.
> I am trying to use colour to pick out spam identified by a Spam program in
> an X-Header.
> I have gone into the advanced settings, but can't seem to fin...Payroll deduction based on percentage of another deduction
Is it possible to set up a payroll deduction based on percentage of another
deduction? I see we can base a deduction on selected paycodes but not
deductions. We can collect a percentage of wage attachments as collection
fees but if the wage attachment deduction amount changes each pay, we'd have
to manually change to collection fee code each pay. I'm looking for a way to
calculate this collection fee automatically.