Trouble With Cell Format
I am trying to type this number 3660884001738 into a cell, but Excel changes
it to 3.66088E+12?? I have tried to format the cell to text, to number,
basically to all formats, but it still stays the same. What am I missing??
Thanks for any help
Custom format 0
or preformat as text before you enter it
"JR" <email@example.com> wrote in message
> I am trying to type this number 3660884001738 into a cell, but Excel
> it to 3.66088E+12?? I ...how do i insert a document in publisher 2003?
I have several documents that were written at different times in Pub 2002 and
Pub 2003. Is there any way I can put two or more of those documents into a
single Pub document that I can then print as one document?
> I have several documents that were written at different times in Pub
> 2002 and Pub 2003. Is there any way I can put two or more of those
> documents into a single Pub document that I can then print as one
Yes. It's called copy and paste. There's no other way.
My great-grandfather was born and raised in Elgin - did he even...Can I prevent Excel converting to date format?
I was wondering if there was a setting or any way to prevent Excel from
converting certain numbers to dates.
e.g. 11/7 will be converted automatically to 11/07/2005. This appears
as 11-Jul in the cell. This problem also happens with 11-7.
This is very annoying because it would appear that there is actually no
way of having two numbers (which happen to be low enough numbers to be
dates) separated by a forward slash or a hyphen.
Has anyone found a solution to this problem yet?
If you're typing these values into the cell, you can either prefix them with a
...Formatting exponentials in Excel
I am trying to set up a spreadsheet that has a formula for the
available space which is = total - used
The thing is the space is GB or MB (1x10^9 or 1x10^6)
I formatted the numbers to display 1000000 as 1.00E+06 but is there
anyway of making this into 1MB so it will still calculate correctly?
Hope that makes sense,
Please keep all correspondence within the Group, so all may benefit!
"N...Outlook 2003 and Office 2000 compatibility
We recently upgraded to Exchange Server 2003 and Outlook
2003 came with it. We have stayed with Office 2000,
though. Now we can no longer use Word to edit email
messages and when we are in Word we can't right click the
document to send as an email. Does anyone know why this
is or a work around?
No workaround available -- you will have to upgrade to Word 2003, since
versions have to match to use Word with Outlook.
"Jeanie Achterberg" <firstname.lastname@example.org> wrote in message
> We recently upgraded ...convert from .xls format to .csv format
Can anyone help me to convert .xls to .csv without changing the
content. I want the leading zeros to remain in the csv.
Thanks in advance
m_ravindran's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28668
View this thread: http://www.excelforum.com/showthread.php?threadid=483430
take a look at the Text Write facility at
I am not an experienced Access 2007 user so this may be an easy one.
On my reports I want certain lines to be bold depending on certain criteria.
The criteria is basically: If Date A is before Date B AND the difference
between Date B and Date A is less than 3 years then I want that record in
Can this be done? The dates are in my query that my report references. Do
the dates have to be part of the report. I have used advanced filtering on
fields not in the report and it works so I hope I don't have to include them.
Message posted via http://www.accessmo...Pivot tables
Two questions regarding pivot tables.
Is there a way to use auto filter to limit the items included in row
fields? That is, instead of checking or unchecking items in the drop
down box use filters to say only include accounts greater than 5000 and
less than 7000. I got around this by filtering the source of the data,
copying it to another sheet and changing the source of the pivot table
to the new sheet, but that is cumbersome.
Can conditional formatting be used within pivot tables? I have an
actual field, a budget field and a calculated variance field. I would
like to have variances...filtering data and condensing a form format
I wish to print out weekly payroll receipt in form-like format for employees
only if employee worked that week. I have an Excel file composed of many
worksheets each for a given employee. In upper lefthand corner of these
worksheets are employee name, address, phone, etc. In upper righthand
corner is marital status, dependents, tax rates, etc. Below this: column A
is pay week ending date, column B is pay rate, column C is hours worked, D
is Gross Wages formula, E is SS Tax formula, F is Med Tax formula, G is Fed
Tax formula, H is State Tax formula, I is Local Tax formula, J is State...Outlook 2003 - Exchange Server 5.5
I have installed Outlook 2003 and I want, that the size of my .ost file
exceeds 2gb. Is this possible with exchange 5.5 in the background? I know,
that pst-files can exceed 2gb - nearly 4 tb in unicode mode, what will be
enough for the next few years :-)
How can I do this?
Exchange 5.5 does not support Unicode OST files. What you get in that
version of Exchange with Outlook 2003 is cached mode but not with larger OST
files. The 2 GB limit still applies.
[MVP - Outlook]
Author: Absolute Beginner's Guide to Microsoft Office ...Is thier a Publisher Converter for 2000 to use 2003 Files
A co-worker has Publisher 2003 I have Publisher 2000 we share files on the
network but she always forgets to save to the older file format is their a
way i can get a converter for 2000 to use 2003 files
No - you'll have to teach your friend to remember a little better or is that
MVP Microsoft [Publisher]
"srhenke" <email@example.com> wrote in message
>A co-worker has Publisher 2003 I have Publisher 2000 we share files on the
> network but she always forgets...Copying a format that has been conditionally formated
How do I cut and paste a formula picking up it's own values if the cell has
been conditionally formatted.
In example, c3 is to highligh in red/bold if it's value is lower than c29
(the value of the same info from year prior). It worked for that cell but I
want to copy the formula for the rest of the 500+ cells so that d3 also read
from d29, etc.
What, exactly, is the condition you set? I'm guessing it's something like
'formula is' =($C$3<$C$29). If you use relative cell references, =(C3<C29),
rather than the absolute references, then you should ...Exchange 2003 Mapi error 5
Each time we start the services on our exchange server we get the following
Event Type: Error
Event Source: MSExchangeES
Event Category: General
Event ID: 5
An unexpected MAPI error occurred. Error returned was [0x80004005].
For more information, see Help and Support Center at
Has anybody come across this before?
That error translates to 'Access Denied.' Looks like you are getting this
for the Exchange Event Service. That service is there for leg...opening non responsive word
After using the Microsoft Office 2007 program for a year it has suddenly
become unresponsive. If it does start it will open then freeze and say 'not
responding' or will not open a new document or any saved documents at all. I
have tried changing the template normal.dotm to normal.dot and changing the
HKEY to old options/ old data, in the hope it would create new data but it
will not open saved documents. It only opens after winword.exe /a but is
unresponsive to demands. I have also uninstalled the program then reinstalled
and rebotted but nothing has helped. Is it Windows...Problems with a Contact in Outlook 2003.
The issue is that I have a contact in Outlook that the e-mail address
is automatically resolved to something else by Outlook. It's actually
the same e-mail address with an exclamation mark added to it right
before the @ sign. I deleted the contact and tried adding it again,
however, this time it wont let me type in an e-mail address. As soon as
I tab on to the next field or save the contact info the e-mail address
that I just typed in disappears. I have tried searching for the *.nk2
file but I am unable to find it.(This after I changed the file settings
to show hidden files and folders)
I...SBS/Exchange 2003: Email Messages leaving SMTP queue then disappea
I have been working for almost 3 days to see what my Exchange Server 2003
(running on Small Business Server 2003) has not been delivering email
messages to outside receipients, i.e., firstname.lastname@example.org . I can successfully
send email inside the domain to another domain recipient using Outlook such
as email@example.com to firstname.lastname@example.org and I can receive email from outside the
domain, such as from email@example.com.
I have looked in the queue and watched the messages leave the SMTP queue and
then they disappear into the ether. I can telnet to port 25 on the Exchange
server and it...Retriveving numbers formated as text ?
I have setup a worksheet so that when someone inserts a plan
information about the plan number appears. The plan number
unfortunately are in one of the following combinations, 144 144.
144.1B . I have formatted the cells to be TEXT, but when someon
inserts 144 no information is retrieved. The only ones that work ar
144.1 and 144.1B. Also when i hightlight all cells and format as TEX
the little green 'thing' shows up ONLY on 144.1 and 144.1B and not o
144 . I hope i've been clear. Thank you
Message posted from http://www.ExcelForum.com
When retrieving the...Avoid user having to enter hours when using [mm]:ss format
I am formatting a spreadsheet to enter sports-score from a particular event.
I format cells to display mm:ss using "custom" format [mm]:ss. However the
user, it appears, has to enter 00 for hh to get the display correct. How can
I avoid this?
as a starting point:
"Lady_luck" <Lady_luck@discussions.microsoft.com> schrieb im Newsbeitrag
> I am formatting a spreadsheet to enter sports-score from a particular
I have a skide show that was prepared in Corel Presentations and will only
open in Presentation 8 runtime. Anyone know how I can convert it to open in
Not a Publisher issue. Perhaps if you posted in a Corel newsgroup you'd get
MVP Microsoft [Publisher]
"colcav" <firstname.lastname@example.org> wrote in message
>I have a skide show that was prepared in Corel Presentations and will only
> open in Presentation 8 runtime. Anyone know how I can c...Can not use Left Click to login to Windows XP SP3 with MS Mouse
Hardware: I have a Dell D610 with trackpoint and touchpad. I am installing a
MS Wireless Keyboard 6000 v3 and a MS Wireless Mouse 6000 v2.
Software: Windows XP SP3, fully patched, clean re-install. Intellipoint and
IntelliType v6.31 installed. Latest ALPS Touchpad driver from Dell.
When running _without_ the MS Keyboard and Mouse, the system runs as
expected. Using the ALPS Touchpad, booting up, the Welcome screen works and
all clickable objects are recognized and you can easily login. Start menu is
When running _with_ the MS Keyboard and Mouse, the system doe...How do I underline words without underlining the whole field?
I have created a database in the form view. I would like to be able to
underline certain words in one of the fields without underlining everything
in the field. Anyone who has some helpful advice would be greatly
In a form? I think the only approach would be to use RTF.
It's possible in a report, though, with some limitations: see what Stephen
Lebans has at http://www.lebans.com/mixbold-plain.htm
While you're at Stephen's site, check his free RTF control at
Doug Steele, Microsoft Access MVP
(no e-...Format a Cell from VBA
I've got a macro that does a bunch of things and at the end puts a number value
in a cell. I would like to write out that value to be displayed in a fixed
format with one decimal digit. Somehow it *almost* works for me. I've tried to
use a statement like:
ActiveCell.Offset(0,0) = FORMAT(X,"0.0")
When X is some kind of long decimal like 1.33333 it works nicely and shows "1.3"
in the cell as expected. When X is an even integer like 1.0 though, it only
shows "1" in the cell. Yet from the spreadsheet I can click to set the number
of digits af...Any way to perserve Pivot Table formatting
At least the borders? We have a pivot table that has many columns of
data (18 months) and it is very useful to have an underline or row
shading to help follow across this large table.
We can set the borders and it works OK, but as soon as the data is
updated, the format is removed. Even as simple as selecting one of the
categories from the drop down clears the formatting. This doesn't seem
What are we doing wrong? Should the formatting be set immediately
after creating the table? Or is there some trick to this?
Tried to pick a report style, but picking one seemed change the table...Data Migration from MS CRM to MS CRM?!?
I have still the same problem and I still can't find a solution...
- We worked with the sample database "Adventure Works Cycle"
- Since Monday we have a new licence key that works only with our company
1) How can I change the company name to get the key work? (I think this
Second Possibility: I installed the MS CRM Professional 1.2 (German) again
with the right company name. But then the existing database cannot be
connected, because it belongs to the Adventure Works Cycle company.
2) How can I connect the dat...Format conversion
Is there a means by which I can use .pub files in
Nope. And only the Publisher version that used to create the file, or later
version can open the Publisher file.
Vancouver, USA, a great city in one of the 45+ countries in America!
"Steven Robinson" <email@example.com> wrote in message
> Is there a means by which I can use .pub files in
> PictureIt! 2001?