Adding zero's to the beginning of a number #2
I'm trying to enter a number into a cell and because the number I nee
to add starts with zero's, Excel automatically changes the number an
removes the zero's. For example, I'm trying to enter the number 00709
and after entering it and going to another cell, the number i
automatically changed to 7099. Is it posisble to keep the cell showin
the numbers like I need them? If so, how do I do it? Thanks
Message posted from http://www.ExcelForum.com
Simplest way is to add an apostrophe before the number, eg '007099.
If you are entering a lot of numbers, s...Team Folders migration from 5.5 to 2003
Are there any known issues with migrating Exchange/Outlook Team Folders from
Exchange 5.5 to Exchange 2003 using PFMigrate? We have many Team Folders on
our older Exchange 5.5 server that we MUST migrate over to Exchange 2003
with full functionality
These are Team Folders created with the Team Folders Wizard? I don't know
whether PFMigrate will migrate the folder home page setting and the custom
form that a couple of the folders use. You may need to handle those
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
...formula problem #5
B C E
Comp time hours Total Compt time Compt time used Compt time balanc
3 12 12 16 -
4 12 24 0
5 12 36 0
6 12 48 0
7 12 60 0
8 12 72 0
9 12 84 0
10 84 3
11 0.34 0
12 84.34 0
In the above spread sheet I am having a problem getting the formula to work in the Compt Time used column. What I have used is the following
Compt Time used: =if(E3="","",SUM($E$2:E3) How can I by pass the circular reference error? Also when I fill the formula down it d...Exchange 2003 Problem with Message forwarding
I've got a mailbox with auto forwarding forwarding to external address. This
forwarding has since been turned off and the contact it was forwarding to has
since been deleted from the active directory.
The problem i'm having is that Exchange is still trying to forward all
messages to this external address. For every message the user recieves there
is an NDR sent to the user, I've blanked the user and domain details from
The following recipient(s) could not be reached:
*************** on 26/01/2005 09:08
The e-mail account does not exist at the organiz...Using Random Weight UPC Bar Codes in RMS 1.3
I am wondering how to set-up inventory in RMS of beef that my vendor
purchases from a butcher in bulk, say in 100 pound lots of T-Bones, that are
then individually wrapped and UPC'ed by the butcher. The butcher is UPC
labling them according to the standards of such as defined on page 188 where
the first series of numbers identifies the product "T-Bone" and the next
series is weight in 1/100's of a pound increments. The original PO is for 100
pounds of T-Bone and 100 pounds would be received as one lump sum receipt.
Note that the store does not want to take in invento...Email large messages
Hi, I have to email large DWG & zip files attached to
email messages and have been having trouble with breaking
apart large mess. in outlook express. I set maximum file
size to 1500KB but they never seem to get reconstituted on
the receiving end. If I send a message with a 6MB
attachment the receiving end gets 4 file: 1 of 4, 2 of
4.... 4 of 4 and so on and they can not do anything with
Thanks for any help.
This newsgroup is for support of Outlook 97, 98, 2000, 2002 & 2003 from the
family for Intel PCs. For Outlook Express (OE) support try posting in one of
thes...Visual C++ Error #2
I get the following message periodicaly when closing Outlook 2002:
Microsoft Visual C++ Runtime Library
This application has requested the runtime to terminate it in an
unusual way. Please contact the application's support team for more
The event occurs primarily when exiting Outlook. I have searched for an
answer on many differnt areas, yet have found no solutions.
I do not have Norton Anti-virus which has appeared to be a problem for
Outlook, (we use Command, and it doesnt have any outlook plugins).
The frustrating thin...How large is a chart?
I am just asking out of curiosity. How large, in kilobytes, is a chart; say,
a 1000-point x-y scatter? I had a large file whose size was halved when the
charts were deleted (actually, they were lost, along with formats and
scenarios, when the file got corrupted; see "story" below).
In my non-expert view, it should not be so large, because the only
information unique to the chart is its position, size, format, and similar
details. The actual data itself is contained in the data-range cells, so
should not have to be repeated in the chart itself. Not only the formulas
but th...Problem creating first public folder #2
I have SBS 2003 with Exchange 2003 installed. I have
problem when trying to create the first public folder. I
get an error message with the ID n. ID no: 80040E19
Can anyone help me with that ?
...Migrate Data from Great Plains 7.5 to Sage Line 50 v12?
I have Great Plains 7.5. I want to move to Sage Line 50. How do I get
the data out?
What DBMS are you on? MS-SQL, Btrieve...?
Richard L. Whaley
Author / Consultant / MVP
Documentation for Software Users
> I have Great Plains 7.5. I want to move to Sage Line 50. How do I get
> the data out?
...Publishing Reports in 3.0
Just wondering if anyone has successfully added a new report in 3.0.
I'm following the SDK steps but when I click "Save" (to save the new report)
I get an erro (below).
Any ideas on what I'm doing incorrectly.
btw ... what's the beta newsgroup (microsoft.crm.beta?). We got access to
the TAP3 group but there's no postings????
Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originat...Excel find and replace issue #2
When I go to Edit - Find - find and replace -
and have something copied I want to look for,
When I click paste Nothing happens.
This has only been going on for a few days.
Have any ideas what got accidently (or updated) changed?
Will it paste if you use the ctrl-v shortcut?
> When I go to Edit - Find - find and replace -
> and have something copied I want to look for,
> When I click paste Nothing happens.
> This has only been going on for a few days.
> Have any ideas what got accidently (or updated) changed?
YES it Will.
So is it j...What settings needs changed in order to merge from an access data. #2
I had created a certificate in publisher and was merging the names from a
query in access. The techical support center upgraded our machines and now
the merge will not work. What settings should I check to make this work
Please help me: I have a big problem for some weeks, I
can nomore open the attachments, and have this message
OE removed access to the following unsafe attachment in
your mail: .......
It can be photos, plain Word text, or web pages it is
always to same thing.
Thank you for your help
Open Outlook Express and select Tools | Option | Security tab and uncheck
the second box from the top concerning attachments.
Neo [MVP Outlook]
Due to the Swen virus, all e-mails sent to this account will be deleted
"andree katz" <firstname.lastname@example.org> wrote in messa...Exchange 5.5 mailbox useage report
Can anyone give some ideas on how to produce a report of 'active' mailboxes?
In other words when the mailbox was last accessed?
I would guess that the last time they logged into AD would be the last time
the mailbox was used. Are there any other ways to find out this information?
We can get the last access time in Exchange Administrator.
-- Open Exchange Administrator
-- Expand Server/private information store/logons
We can also log the logon events to application logs
-- Open the properties pane of the Exchange 5.5 server in Exchange
-- Sw...Drop-down list #5
I created a drop-down list in a separate sheet in my workbook. I named it
Vehicles. Now I want to add to the list, but I can't figure out how to do it.
I know ig must be so easy, but I'm stumped. Please help.
If it's a one-time occurrence, you can press Ctrl+F3,
click on the name, and extend the formula. Otherwise, I
would make the range dynamic. You can learn how to do
>I created a drop-down list in a separate sheet in my
workbook. I named it
>Vehicles...publisher 98 #4
The file size of my 4 page newsletter created with
Publisher 98 (I am using the supplied template or wizard
called "Blends") jumps from 165 KB with no photos to
17,000 KB with 6 photos added. I have sized the photos
and checked their file size in Photo Editor - they add up
to 476 KB when I look in Windows Explorer.
I've had this problem repeatedly with newsletters. Thanks
in advance for any suggestions.
Hi jeff (email@example.com),
in the Microsoft� newsgroups
|| The file size of my 4 page newsletter created with
|| Publisher 98 (I am using the supp...2 panel brochure printing in publisher
I am trying to print a 2 panel brochure in publisher and when I print preview
everything fits but when it prints pages 1, & 3 get cut off. I would like all
the pages to fit and print so the pages are aligned when folded. its an 8x11
I don't know which margins to use to make it print correctly.
Have you setup your brochure as a booklet? Do you know your printers margin
limitations? A tutorial is here:
Mary Sauer MVP
"Dominikin" <Dominikin@d...Auto Numbering #5
Can any one help me with this? I am trying to number a cost tabl
sequencially from A.1.1, A1.1.2 and so on. Can you do this in Excel
And can you make to where if you insert a row in between the rows tha
are already numbered that it changes everything automatically? Pleas
jharkins's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2565
View this thread: http://www.excelforum.com/showthread.php?threadid=39099
Using Excel 2000, I entered A.1.1 in a cell. Then I used my mouse a...Filtering features in Exchange 2003
Can someone point me to some documentation that describes how one can use
the built-in filtering features that are in Exchange 2003?
Please do not send email directly to this alias is for newsgroup purposes
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sabo, Eric" <firstname.lastname@example.org> wrote in message
> Can someone ...Year to Date Amount on Payroll Check
We just printed out our first payroll check for 2007. The amount for the
check printed fine but the Year To Date amount is double the amount. In some
cases, YTD amount is triple of less than double.
How do we fix this problem and where is this data stored?
...Plotting & x axis labels
I have a fixed start date and end date for the x axis
range - 9/18/2000 - 6/28/2003, and i have 10 dates that i
want to plot between these dates. I want the x axis to
display only the fixed start and end dates.
The dates to plot are;
I have the dates plotted but i cannot get the end date of
6/28/2003 to appear. I don't want to add 9/18/2000 and
6/28/2003 to the data series because it will look like a
Could someone help please?
First let's make sure...Removing 5.5 Server
All - preparing to remove the last 5.5 server from our site after upgrade.
What I would like to do is just turn it off for a week or so just to make
sure there are no issues and then go through the formal turn down of this
Can this be done simply by turning it off and adjust DNS to point to the
2003 server? If not, is there a way to accomplish this?
you might want to look at this:
Susan Conkey [MVP]
"Doug" <email@example.com> wrote in message
> All - prep...Group Emails #2
Is it possible in Outlook 2000 to send an email to a group
of recipients but when each recipient receives the email
only their address shows in the recipient window and not
everybody else in the group?
You can hide all addresses by using the BCC field or you can use the Mail
Merge wizard from within Word.
Roady [MVP] www.sparnaaij.net
Microsoft Office and Microsoft Office related News
Also Outlook FAQ, How To's, Downloads and more...
Tips of the month:
-Save Embedded Pictures in Their Original Format
-Create an Office XP CD slipstreamed with Service Pack 3
"...Publisher 2003 VS Publisher 2003 with digital imaging
Can someone tell me or point me to where I might find information on the two
Pub 2003 editions? What is provided in Publisher 2003 with digital imaging
that is not provided in plain publisher 2003?
a.. Microsoft Office Publisher 2003
a.. Microsoft Office Publisher 2003 with Digital Imaging
After managing to set up OE-QuoteFix on his new PC, Ed reads a message
from Rufus J CHaney <firstname.lastname@example.org>...
> Can someone tell me or point me to where I might find information on
> the two Pub 2003 editions? What is provided in Publisher 2003 with