number rounding in MS Excel
This may have been answered many times.
In MS EXCEL is there a way that it calculates all numbers to 2 decimal
digit accuracy instead of the 15 digit default?
Thanks in advance for the answer.
You can set your decimal places in your cells as 2 and then check Precision
As Displayed on the Tools / Options / Calculation page. Be careful though,
it means what it says!!
"mahusain" <email@example.com> wrote in message
> This may have been answered many times.
> In MS EXCEL is ther...Opening publisher 97 with a later version
I have publisher 97 on my windows xp and it works fine. However, I had someone refine some work I had done and apparently they used a later version of Publisher because when I loaded their CD, I got the message "Publisher cannot load files from a different version"
What can I do--does this mean I have to buy a later version to match the version he used, or do I have to buy one of those programs that can open other programs. If I do the later, will I be able to use my 97 version to make changes once I get the files open on the later version
http://www.mvps....Can you insert a picture into a specific cell?
Or do they only "float" on the page.
They float over the worksheet, but you can adjust the size so that it seems to
fit a cell exactly.
If you insert a picture, you can hold the alt-key down while you move/resize the
picture. When it gets close to the edge of a cell, it'll snap-to that edge.
> Or do they only "float" on the page.
...open two different Access reports
I was wondering if i can get some help here. I have two different reports
that i want to open when a user clicks a button to view the reports for
printing. Is there any way of popping them up at the same time in VBA?
Thank you in advance
>I was wondering if i can get some help here. I have two different reports
>that i want to open when a user clicks a button to view the reports for
>printing. Is there any way of popping them up at the same time in VBA?
>Thank you in advance
Yes. Call the DoCmd.OpenReport command twic...Unable to open Outlook Express after upgrade to Win. XP
I upgraded from windows98 to windows XP Pro. Now when I
try to use OE I get two error messages.
"Outlook Express could not be started. The application
was unable to open the OE message store. Your compter may
be out of memory or your disk is full.....0x800c012e,3"
"OE could not be started because MSOE.DLL could not be
initialized. OE maynot be installd correctly"
I found a similiar problem fix for window2000 which said
to delete OE, rename the old folder, then edit the
registry and reinstall. I did the above but was not
allowed to rename the old folder and th...Opening an *.MSG file with it's respective attachment.
The file *.MSG is a message file. This can be viewed by any editor, like
Notepad. However, when there's an attachment to it, we see garbage.
Is there a way to open the attachments present inside the *.MSG files ?
Yes, by opening it with Outlook.
Microsoft Office and Microsoft Office related News
Also Outlook FAQ, How To's, Downloads and more...
Tips of the month:
-Create your own fully customized Toolbar
-Creating a Classic View in Outlook 2003
Subscribe to the newsletter to receive news and tips & tricks in your
mailbox!...Can't open 2005 data file after reinstalling Money 2005
I am experiencing a recurring problem. I have had to reinstall Windows XP
and MS Money 2005. I am now unable to open my previously converted 2005 file
or restore any backup version. I consistently get the following error
"Money cannot locate filename or cannot open it, possibly
because it is a read-only file, you do not have
permission to change it, or your disk drive is write-
protected. If you have chosen the correct file and it
cannot be accessed, you will need to click OK and then
Restore your most recent backup file."
Any help or thoughts would be greatly ap...Send to certain person using specific email account
I send an email to a certain receipient but don't want to use the
default email account.
Is it possible that when I send to them (plain text) , that it will
choose the other account I want to use to send it? Please advise how I
set this up.
I do not believe that this can be achieved automatically through standard
use of Outlook as you need to manually specify the name of the account to
send from if different than the default.
However, it would be possible using the Outlook object model. An Addin would
need to be developed that monitored each mail item prior to sending. If the
d...SpreadSheetML (XML for Excel)
A client of mine has Office X for Mac. I am wondering if this edition
of Excel supports SpreadSheetML. I have heard that it also support the
new Open XML formats (same as Office 11). Does anyone know if either of
these statements is accurate?
Thanks in advance,
I believe that both statements are wrong.
The XML converter for Office Next on the Mac has not yet been developed.
It's not likely to come until after the PC Office team ships their product
to retail -- until they stop CHANGING the thing :-)
My guess is that the converter won't appear until sometime...Public Folder link to Excel File
I have a user that claims that he had a shortcut to a spreadsheet "in
his public folders" at his old job. Obviously, he's an end user that
may or may not know what he's talking about.... I'm trying to figure
out the best way to accomodate him.
He basically wants an Excel file stored on a shared folder to be
available to all user as either a shortcut, or a link in the public
folders (can't post to a folder as he will be updating the sheet
regularly). When a user clicks on the shortcut/link, it would just
launch Excel and display the file.
Anybody have any ideas...Filters in Excel 2003
I am using Filters in Excel 2003.
Every cell in sheet B is linked to every cell in sheet A. That way I
can alter data in B without corrupting the original data in A. I then
highlight the cells in B that I want to assign a filter to and select
Advanced Filter. I have no criteria so I do not set that. I click OK.
I then select Filter again and this time select Auto Filter. Drop
down arrows appear at the top of my columns. Great, no problems so
far, I then select from the drop down list the criteria that I want to
filter. Again no problems, my list filters correctly.
But once I have do...Excel Opens Without Displaying Workbook
I am having issues with opening an Excel file. The file opens, but the workbook is not displayed. I tried the resolution in the article XL97: Excel Opens Without Displaying Workbook (http://support.microsoft.com/default.aspx?scid=kb;en-us;158996&Product=xlw97), but neither of the resolutions fixed the problem. Any suggestions??
Are you using Excel 97?
Fort Collins, CO
>I am having issues with opening an Excel file. The file
opens, but the workbook is not displayed. I tried the
resolution in the article XL97: Excel Opens Without
Di...opening .pst archives
I am trying to open an outlook e-mail archive file (pst)
that was made when I had Office 98 and transferred to my
new computer (Office 2003 Pro).
I am looking for an old e-mail that has now become
evidence in a lawsuit.
Can anyone help?
You didn't say if the PST file was on a CDR/RW, hard drive, or network
share. In any case, the PST file must be located on a local/network drive
where you have full access (read, write, modify, delete, .etc) rights. Once
the file is located in said place, you can open the PST file via File | Open
| Outlook Data File. To close the PST file when you ...Opening pub files created with older Publisher versions #2
I have just upgraded to Publisher 2003 from 2000 and am having trouble with pub files sent to me for our chuch newsletter
which is using Publisher 97
The text is not wrapping around graphics boxes. Can I fix this? I really don't want to go back to Pub 200
Richard this is caused by Publisher 97 not been printer independent.
Even if you went back to Publisher 2000, unless you have the identical font
versions and printer driver you would have issues with formatting.
It sounds like the person sending you the file has a garbage HP inkjet
printer. Get them to install the HP5P laser p...Office 2003 Service Pack 3--subsequent problems opening Publisher
I run Publisher 2003 on Windows XP. On June 13, I updated my system with
Office 2003 Service Pack 3 so that I could open Word documents with the file
ext docx. Subsequent to the Service Pack 3 installation, whenever I open a
Publisher file (which I created), I get the following message: "Publisher has
detected a problem in the file you are trying to open. If you are certain
that this file came from a trusted source and does not contain harmful
information, click OK." What is causing this and is there a way to stop this
Error message when you...Help me identify my missing permission (Cannot open public folder) -2147217843 (Maybe Authentication Fails?)
The following snippet of code throws an error number -2147217843. When
I googled this error code, I see many references to authentication
failed. I am assuming my problem is some kind of permission related
problem on the "MyNewFolder" public folder.
-- start code ---
Dim objFolder As New CDO.Folder
Dim f As ADODB.Field
'sURL is like: file://./backofficestorage/mydomain.com/Public
objFolder.DataSource.Open sURL, , adModeReadWrite, adFailIfNotExists
--- end code --
I have code that runs before this that actually creates the
"MyNewFolder" publ...View original Excel after saving over it
In error, i hit save instead of save as. I'd like to view the original
documents contents. is this at all possible. i use windows xp. excel 2003
Not very likely.
Try a Google search action if you haven't already, but I think it's
This underscores the importance of backups.
http://www.wimgielis.be = Excel/VBA, soccer and music
> In error, i hit save instead of save as. I'd like to view the original
> documents contents. is this at all possible. i use windows xp. excel 2003
In article <C2A3F0E7-24E0-43A5-809A-ECA719...printing imported gif files in Excel
When printing gif file with transparent background on the
grey(25%) background of Excel non-transparent part of the
picture has white border around it. Is there any way to
Thank you in advance...
I am working on a spreadsheet for work where it will calculate commissions to
be earned based on my sales. There is a table that I have to use to determine
what the percentage would be, how would I write an equation for that. For
example, the equation would have to say: if say D3 was = or < than %, use
cell# whatever and then have a sum in there. The table is on another sheet in
the document so that would have to be there too.
Basically, the way that my commissions are calculated is that we have to
take what I sold in any given month and find out what percentage of my yearly
plan i...Some Excel formatting functions taking a long time to work #2
Excel 2000 SP3
When I use some formatting functions for the first time in a
session, such as bold, increasing font size etc, it takes up to 30
seconds to work. Meantime Excel is locked up until it completes that
formatting call. I suspect faulty DLL?
Has anyone experienced this? How to fix (other than a complete re-
Any advice appreciated.
On Nov 5, 8:39=A0am, Piri <wiremu.pare...@hotmail.com> wrote:
> Excel 2000 SP3
> When I use some formatting functions for the first time in a
> session, such as bold, increasing font size etc, it takes =A0up to 30
> secon...opening a .docx with word 2004
Operating System: Mac OS X 10.3 (Panther)
How can I open a .docx attachment that has been sent to me with word 2004?? Can I convert it somehow at my end or does it have to be converted from the sender end?
Thanks for any help...
> How can I open a .docx attachment that has been sent to me with word
> 2004?? Can I convert it somehow at my end or does it have to be
> converted from the sender end?
Make sure that Office is up to date (or at least in version 11.5.0 - the
altest version being 11.5.1) and install the XML convertrs you'...Effectively stoping open relay.
I have a client who started using exchange 2003 few days back. This client
is having more than 12 subnets starting from 172.27.50.0, 172.16.0.0 to
172.27.0.0 and 10.172.172.0 & 10.172.173.0 subnets in different location in
town which are conneted by DSL. This users are connecting to the Exchange
Most of these users are POP3 users.
I have 2 SMTP Virtual Server running. Default SMTP Virtual server
172.16.5.25 and the second for Externel.
In the Mail connector I have added only the external as the local bridgehead
In the relay properties of the internal I...How to save Japanese characters in CSV format of Excel ?
I would like to know, how to save the Doubly-Byte characters.For example,
Japanese in CSV of Excel.Here are the steps, I tried.
1. Open Excel
2. Copy pasted the Japanese charactesrs in a cell.It is displaying the
3. Save as CSV(Comma seperated file)
It is saving as ??????.
Thanks in advance for the info.
I need a macro that help me to transfer name and address information from an
specific table in excel to a template in words on specific areas and then
print the word document.
The reason for this is that i need to create diferents letters to be sent to
the customers from the excel table.
Example of the table is:
soc seg, customer name, child name, customer code, add 1 , add2, city,
estate, zip code. all this information will be paste on word letter template
on specific areas or fields.
IMHO the best approach would be to set up a mail merge documen...Excel fun patch
Excel fun patch, have you see it?