How can I add numbers but ignore the minus signs?
How can I add numbers but ignore the minus signs? In the following, the
answer I'm after is 17
Gord Dibben MS Excel MVP
On Thu, 07 Jun 2007 04:19:52 GMT, Invalid <email@example.comINVALID> wrote:
>How can I add numbers but ignore the minus signs? In the following, the
>answer I'm after is 17
Gord Dibben <gorddibbATshawDOTca> wrote in
Thank you Gord.
> Gord Dibben M...Make excel so it can be printed off, chart and all.
I do our monthly budget on excel and would like to print it off chart and
all, how do I do that without cut and pasting it into Microsoft Word then
If the chart is embedded on a worksheet, it should print when you print
If it's on a chart sheet, you could print that sheet separately.
Or, move the chart to a worksheet, and print it there.
To move a chart, right-click on it, and choose Location.
Select one of the options, and click OK
> I do our monthly budget on excel and would like to print it off chart and
> all, how do I do that without c...synchronising data in 2 excel files
i have 2 identical excel files updated by 2 different people. How do I
synchronise the data into 1 file?
...how can i feather pictures in publisher?
Use an image editing program such as PhotoShop, PhotoDraw, etc. Publisher is
not an image editing program.
Microsoft Publisher MVP
This posting is provided "AS IS" with no warranties, and
confers no rights.
"bscott" <firstname.lastname@example.org> wrote in message
Use a photo editing software program and then insert the resulting picture
MVP Microsoft [Publisher]
"bscott" <email@example.com...can I use a CArchive with a CSocket to read regular text?
if so which type do I use in the CSocket OnReceive function:
ar >> char* didn't work
CArchive can only interpret things that were written by CArchive. Even
text. To receive plain text just pass the text buffer to Read.
Scott McPhillips [VC++ MVP]
Scott McPhillips [MVP] wrote:
> CArchive can only interpret things that were written by CArchive. Even
> text. To receive plain text just pass the text buffer to Read.
> Scott McPhillips [VC++ MVP]
...Going Live with GP
I plan to start using GP Sept 1. We have not transferred any historical
transaction from the old accounting system.
All of our Vendors, Customers, Inv Items etc. are entered and we have tested
all functions of AP AR GL.
Does anyone have a checklist of things to do when starting with a new GP
I understand the basics things such as
Enter open invoices in AP and AR
Enter open POs
Enter begining GL account balances fromt the old accounting system
Begining bank balances and so on.
I just want to make sure that I'm not overlooking something so a check list
from someone ...What is the Outlook 2007 "PST" file called and how do I find it?
In prior versions of Outlook, I could always find the Outlook user
data by scanning for PST file type. I've got a machine in which an
eval version was used and now expired. I want to save the data for
the day when I might buy Outlook and pick up where I left off.
I can't find a PST file.
News is something someone wants to suppress, everything else is advertising.
- Lord Northcliffe, publisher of the Daily Mail
"Al Dykes" <firstname.lastname@example.org> wrote in message
> In prior ...Migrating data from GP to GP
I have a GP7.5 installation when all data is, and a new GP8 installation on
a different server.
I need to migrate inventory data from the GP7.5 to GP8.
I know that i should use the integration manager. But using it means that i
should know the data source structure which is GP, and this is very complex
because i need to migrate all inventory module, not a few data.
PS: i don't what to make an upgrade because other modules are different in
the 2 installations.
Does anyone have any idea on this issue?
Have tried just using DTS within SQL Server choosing your 7.5 s...Text Alignment with Controls
I have a form that contains both Text Boxes and Combo Boxes.
I have made adjustments to the Text Boxes to best display the text contents,
by adjusting the top-bottom-left-right margins.
However, margin adjustments are not available for Combo Boxes.
Is there a way to adjust the text contents of a Combo Box so that it doesn't
ride up against the top of the box?
"However, margin adjustments are not available for Combo Boxes."
You've answered your own question, haven't you?
There's ALWAYS more than one way to skin a cat!
Answers/posts based on...How on Excel can you draw up a Sports knockout chart of 32 names
I am a competition secretary and would like to know how make presentable
knockout charts on Excel or Word? from 32 single names to 32 with 4 names in
Thank you for your assistance
...GP concurrent user and SQL 2005 CAL
assuming a 10 con-current licenses being installed on 15 workstation, with 15
users in GP.
How many SQL 2005 CAL is needed ?
Server plus user client access license (CAL) licensing requires a separate
Server license for each server on which the software is installed, plus a
user CAL for each user accessing the server.
The user CAL model will likely be more cost effective than device CALs if
there are multiple devices per user (for example, a user has a laptop and
handheld computer accessing SQL Server).
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business...How can I show U.S. country code (+1) in my contacts?
I've moved to Italy, and would like to have the U.S. country code show in my
Outlook contacts (as the code for other countries currently does). I've
changed my default location in the Windows 7 control panel, but this hasn't
had the desired result. Any option settings I'm missing?
Which location did you set, and to what? Did you enable the option to
automatically add country code to your Contacts?
"Matt D." <Matt D.@discussions.microsoft.com> wrote in message
> I...Cannot send mail but can recieve
Cannot send mail, out of nowhere.
Windows live and att/yahoo service.
All settings are correct, tried another port and switched back. Tried
changing a couple other settings but revertted back to original correct
Mail both ways works fine via iphone, same mail account.
No changes were made to anything prior to this happening.
I have read other threads, identical problem, with absolutely no solution
besides attempts at chasing tails when all the settings are correct in the
There is something wrong with the Windows live program, would be nice to
know what it...can't email outside demains
I can not send emails to persons that do not use the same
domain ISP. I recieve this message when i try to
our message did not reach some or all of the intended
Sent: 18/04/2004 8:43 PM
The following recipient(s) could not be reached:
email@example.com on 18/04/2004 8:44 PM
550 5.7.1 <firstname.lastname@example.org>...
Relaying denied. IP name possibly forged [18.104.22.168]
Has anyone got any ideas
See your answer posted to you question asked 20 minutes later. This is not
a chat room.
Milly Staples [M....msg file
Someone sent me a distribution list as a .msg file but I have no idea how to
get it into my contacts. Any help would be appreciated.
Never mind. I didn't think about just dragging them. Too simple.
Jerry <email@example.com> wrote:
> Someone sent me a distribution list as a .msg file but I have no idea
> how to get it into my contacts. Any help would be appreciated.
Try dragging the .msg file to your contacts folder.
...Questions about GP Client upgrade configuration
I'm getting ready to install a Service pack for GP7.5 and my ultimate goal
is to get ready to upgrade to GP8.0. However right now upgrades are very
tedious and below is the whole story.
All the users/clients are identical!
Let me describe what we have done in the past to upgrade and what I want in
In the past we sat down at each client machine performed the install. Then
we logged in as an administrator (Ethoseries required this I think) so the
product can finish loading what it needs. Again we do both steps on every
In the future what I would like to do is in...Date from VBA form comes into worksheet as text
In a form I input a date & when it comes across to the excel worksheet it
recognises it as text rather than a date (even though it looks like a date eg
in worksheet date looks like 16/06/09.
Look forward to your answer.
Make sure its Dim'ed correctly:
Dim d As Date
d = Application.InputBox(prompt:="Give me a date", Type:=1)
Range("A1").Value = d
Gary''s Student - gsnu200857
> In a form I input a date & when it comes across to the excel worksheet it
> r...Fabrication and GP
I need to know how to process a transaction in GP. We are a sales -
distribution center. We do some light fabrication. We need to find a way in
GP to take one part or more parts, do fabrication work with them, then put
them back into the system as a new part. For example, we take drum rollers
and send them to a local fabricator who drills holes in them, inserts
"brushes", then sends them back to us as a brush roller. They charge us for
labor and the additional material and we have a new part.
Currently, we either treat it as a parts sale / purchase. That part is
clean, but a...Upgrading from GP 9 to GP 10
While trying to upgrade from GP 9 to GP 10, I get an error when selecting
the instance of the already installed GP 9: "Index was outside the bounds of
the array". Any ideas?
...How can I count a column of numbers
and return the number of values that fall within certain criteria?
For example, if I have 300 salaries listed, and wanted to group them into
Countif (as far as I know) can only have one argument.
You may want to look at =frequency() in help.
> and return the number of values that fall within certain criteria?
> For example, if I have 300 salaries listed, and wanted to group them into
> these ranges:
> ...GP 9 Upgrade and SQL Server 2000 sp4
per microsoft's documentation sql server sp4 must be installed before
upgrading to GP 9. does anyone know if the sql server sp 4 install is
necessary for the GP 9 upgrade? microsoft's documentation indicated that all
service packs for GP 8 must be installed before upgrading to GP 9, but after
speaking with support, they said the GP 8 service packs aren't necessary.
bottom line: i'd like to avoid the sql sp4 install if necessary as i had to
rebuild my test server after installing sp4 last week.
Since the database requirements for GP 9.0 list SQL 2000 SP 4 a...Hard Drive Crash---Import pst file
I have a back-up file (~ 3.3 GB) of Outlook 2007 from crashed hard drive .
When I try to import PST file I get the following message: "Errors have been
detected in the file" Tried Scanpst.exe to no avail.
When I try to open directly from the recovered file using Outlook I get a
message that the "attachment size exceeds the allowable limit"
Suggestions on how to import/repair PST file would be greatly appreciated.
Is this backup a copy of a pst file or was it created with some backup
Is this file located on the current hd?
Are...Payroll GP 10.0
Got this from a client and not sure what they are doing, but never heard of
this any help would be great.
As I am reviewing the Payroll Deduction Journal from the payroll I just ran
yesterday, I have identified 5 employees whose deductions & benefits did not
calculate. I happen to be one of the 5. There is $$$$$ that did not come
off my pay as deductions; including my 401K. The common denominator seems to
be when employee changes are made, deductions & benefits are made inactive;
even though those benefits & deductions have no part in the changes being
made. Pardon me, ...Can i use rpc over http in VPN environment?
Refer to subject.
...MS CRM integration to GP
Can any one update me wheather the mutiple company
databases can be integrated to MSCRM.
The senario is this.
a company has mutiple entities using GP 7.5 and unique sql
databases,require to integrate mscrm with gp.
The integration that is supplied by MS only allows you to integrate
with 1 company DB. You could probably use some of the components that
are provided, but you will need to develop some of the integration
logic yourself to address this.
On Sat, 24 Jan 2004 05:34:31 -0800, "firstname.lastname@example.org"