Can I enter numbers in a cross functional flowchart?
On Mon, 24 Aug 2009 12:07:02 -0700, carosaam
>Can I enter numbers in a cross functional flowchart?
Do you mean for the process names or function names? Yes.
Regards, Paul Herber, Sandrila Ltd.
Electronics for Visio http://www.electronics.sandrila.co.uk/
Electrical for Visio http://www.electrical.sandrila.co.uk/
Electronics Packages for Visio http://www.electronics-packages.sandrila.co.uk/
...How do I expand the number of characters in Access comment box?
I am using Access 2007 and want to be able to include more than 250
characters in a "Comment" box.
You could try changing your table's field type to Memo. Assuming that
your are talking about a field in a table, that maybe shows on a form. If
that is not the case, please describe precisely what comment box your are
attempting to use.
>I am using Access 2007 and want to be able to include more than 250
>characters in a "Comment" box.
Message posted via http://www.accessmonster.com
...negative number to positive number
How can I change a negative number to positive number
Multiply by -1 or use the ABS() function.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"fgiord" <firstname.lastname@example.org> wrote in message
> How can I change a negative number to positive number
=ABS(##) or mult it by -1
"fgiord" <email@example.com> wrote in message
> How can I chan...Sharing workbook error message
After sharing a workbook, when I go to save it I get this message,
"This workbook is no longer shared'.
...Hide page numbers for mutliple discontiquous levels
I need to hide the page numbers for levels 1 and 7 in my TOC. I used the \n
switch to hide level 1, but cannot find a way to specify multiple ranges for
this switch. Is there a way to do this? I am using Word 2003.
You have to use a trick. See the "Omitting page numbers for noncontiguous
levels" section of
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"Phillip Llacuna" <firstname.lastname@example.org> wrote in me...1-52 pages, 8,000 employee numbers
I have the ultimate challenge: to do job books for 8,000 employees.
The form is completed, but the request is to make booklets of 52 pages
for each employee.
Each page of the booklet must also have each employee's number on it
(0001 to 8000). Each page o fthe booklet must be numbered with the
week number from 01 to 52. Therefore I need to auto generate 416,000
pages. Ridiculous I know but nobody listens to us!
How can I export the above scenario to PDF from Excel?
On Apr 19, 2:17=A0pm, gatecrasherg13 gatecrasherg13
<gatecrasher...@gmail.com> wr...Message times
I just sent a message to a customer at 09.04am. He acknowledged it by
return to say thanks. Looking at the message it says I sent it at
My PC has the right time (uk internet clock) and the customer is here
in the UK too. Where is the error occuring?
Thanks in advance,
Hi, My computer was doing the same thing yesterday, i check the clock time
and zone on computer (which were all ok like yours) the only thing i did was
before i turned it off last night, was click on the update now option under
the internet time option, i dont know if this did it, but today its all fine
again,...Error Message #7
When attempting to start money 2003 receive the following
error message."This application has asked the Runtime to
terminate in an unusual way. Please contact the support
team for more information."
I have uninstalled and reinstalled the program. Same error
a fix that is often the first thing that any support
person will have you try is to go to "RUN" and enter
this is some sort of database repair startup of Money.
give it a try.
>When attempting to start money 2003 receive the following
>error message....Sequential numbering in Number field
When I am entering transactions manually, I will put "Debit" or "VISA" to
indicate how the withdrawl was made. When I download my account information,
Money05 overwrites this with a sequential number. I have to go into the
entry a second time to redo my change. Does anyone know how to turn this
"feature" off? I want my values used - sequential numbering does not help me
in the slightest.
This is not a "feature" you can turn off. It's a reflection of the basic
premise of downloaded transaction data. The presumption with downloading
data...Number of Cells in a column
I want to add this formula in my ESS.
COUNTIF(sheet1!S2:S43,"*Yes*") to find out
the number of value containing "YES".
My concern is I don't have fixed count from
S2 to S43. It could be something else.
What can I do to have this code reusable?
I thought something like
\But it doesnt work
Thanks for your help
Try this if there is nothing else in that column:-
Ken....................... Microsoft MVP - Excel
Sys Spec - ...General Number Format Changed
Excel 2003 on XP
I have a collegue who's Excel setting for General number format displays as
0.1 instead of 1 in the sample box.
ie if you type in "1" you get "0.1", if you type in ".1" (as in 0.1) you get
Where in the settings can this General format be returned to standard?
Sorry that should have been:
ie if you type in "1" you get "0.1", if you type in "1." (as in 1.0) you get
> Excel 2003 on XP
> I have a collegue who's Excel setting for G...How to create an icon to send messages
I have several accounts but I use only one them very frequently .
I would like to create an icon in the menu, so it would be easier to send
or receive messages of this account.
How can I do this?
SantistaS <email@example.com> wrote:
> I have several accounts but I use only one them very frequently .
> I would like to create an icon in the menu, so it would be easier to
> send or receive messages of this account.
Windows accounts or mail accounts? What version of Outlook?
...How to define cells so that only numbers can be filled?
How could I format cells in excel so that only numbers can be filled
The input should be integer e.g. between 0...99 and cells shoud no
accept any other marks, such as space, letters... simply nothing els
Message posted from http://www.ExcelForum.com
Data > Validation
You'll find it pretty intuitive and very flexible as to what you can
do as far a restricting input to a cell.
Norman Harker MVP (Excel)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available fre...Message Queue in Retry Mode
I am running an exchange server called MO. For no apparent reason the Queue
called Messages awaiting directorly lookup is now always in retry mode. The
number of messages is increasing as mails get sent and received. Internal
mail is not working, and external mail is not working.
The system uses a direct SMTP feed. The system is Exchange Server 2003 with
SP2 on a 2 server Domain. The FSMO is on the Primary DC, Excahnge is on an
addition DC. No unusual errors appear in the Event Logs even after increasing
the logging level to maximum on the Exchange Server.
Any suggestions would be appr...Numbering, revisited
While there are already a lot of posts about numbering, I haven't been able
to find the solutions for my specific quandry...
[BTW, I'm posting this under "General" even though ultimately I'd like to
make macros to support the answer -- since a manual solution needs to be the
first step! :) ]
Background: My workgroup is preparing to migrate to Word 2007 very soon.
We create/maintain hundreds of large procedure manuals, each containing
multiple chapters (sometimes up to 40-50 per manual). Each chapter consists
of steps, using multi-level numbered lists...transaction number in PC Charge
Is there any way to manage the fields that should go to PC Charge while
tendering credit cards in RMS. The problem is that transaction number (
called Ticket in PC Charge) doesn't appear in PC Charge and that cost as
...Limit number of characters in a cell
Is there a way to limit the number of characters that a user can key into a
I want to get a list of names and addresses imputted by user, but I don't
want them to be more than 35 characters.
Thanks for the help
Take a look at Data|Validation.
You can have excel yell at the user when they hit enter after typing in a
Dr Senji wrote:
> Is there a way to limit the number of characters that a user can key into a
> I want to get a list of names and addresses imputted by user, but I don't
> want the...Case, Quote numbering
We should have the ability to number the cases without having a suffix. If
we do have a suffix, we should be able to define the suffix.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/defa...Rounding numbers to the nearest thousand
Simple question (i hope)
Is there a simple way i can round numbers to the nearest thousand by using
the format cells command.
i would like to display 1,234.56 as 12
I don't want to be diving by 1000 and rounding to zero decimal places
because i still want the whole number displayed in the formula bar when
i use excel 2003
Format the number as #,##0,;-#,##0, or similar. Not the comma at the end -
this tells Excel to display as thousands (two commas here will display as
Note that 1,234.56 will display as 1 (thousand) not 12.
"...Form of phone numbers in contact list
I am using Blackberry's Desktop Software to syncronize with my MS Outlook
Contacts list. The onboard caller-id function of the phone that is supposed
to correlate the incoming phone number to a name of a contact (should the
number be in my contacts list) isn't working. According to help from
Blackberry the problem is the "form" of the numbers as they're being loaded
on the Blackberry from MS Outlook. Specifically, apparently the fact that
the numbers are stored in the form of (###) ###-#### instead of something
like ###-###-#### is keeping the phone from realizi...Message Box Formating
Is there a procedure that can be used to change the font and background
colors for message boxes?
Enjoy the blessings of the day.
No, you can't change the font or colors of a message box.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Gerald Evans" <firstname.lastname@example.org> wrote in message
> Is there a procedure that can be used to change the font and
> colors for message boxes?
>...sorting numbers and numbers that contain text in excel
A column contains both strictly numbers and also numbers that are followed
by text (e.g., row 1: 1000, row 2: 1500; row 3: 1000a; row 4: 1500a)
Identical numbers are related documents, with the text suffixes referring to
addenda documents; thus, document 1000 has an addendum document 1000a; How
can I sort the column so in the following order: row 1 (1000), row 3 (1000a),
row 2 (1500), row 4 (1500a)?
=TEXT(A1,"0") will turn each into text, then sort by that helper column (and
don't accept Excel's suggestion to treat text that looks like number...How do I update a spreadsheet with numbers input into another?
How do I link two speadsheets in order to update both at the same time?
> How do I link two speadsheets in order to update both at the same time?
Probably something like this
In A1: =IF(Sheet1!A1="","",Sheet1!A1)
Copy A1 across/down to cover the extent
Sheet2 will then reflect entries/updates in Sheet1 for the formulated range
If both spreadsheets are the same, headers, data ranges, titles etc,
basically same architecture on both sheets, then...
While on Sheet1...unread emails message
The welcome screen in Windows XP can show a message for each user giving the
number of unread messages in the user's Inbox. Does this only work for
Outlook Express, or is it configurable to work with Outlook 2003?
I think it only works with Outlook Express since that is integrated with
Windows (part of Internet Explorer.)
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no ...2000
It's a minor thing, but I would really appreciate your
help. I was recently upgraded from NT to 2000. Now,
whenever an email enters or is deleted from the main panel
there is an animated slide of all the other emails
listed. This slide is painfully slow, and I find that
once it has started my system will hold up processing any
other request (like if I clicked to switch windows, it
will stay in outlook until the slide is done, then switch).
I have researched the knowledge base, and I see nothing
there. I have turned off every animation selection I can
find, but the behavior co...