save as pipe delimited #2
just an appendage:
i found another link, which provides a file by Earl which does this.
i am not able to figure out where to input the filename for the data t
be picked up from.
any information regarding this would be helpful.
icestationzbra's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=458
View this thread: http://www.excelforum.com/showthread.php?threadid=26877
I have an issue with users unable to send messages to mail-enabled public
folders in the same organization. Email can be sent to the public folder
from outside. I found this is a pretty common issue but nothing helped
resolve my issue. It appears to be fixed in SP2 however I am still having
problems. I looked at the KB articles listed below and verified the
Anonymous user has the appropriate rights. I see there was a hotfix in
Exchange 2003 RTM and SP1. I also looked at all the AD permissions and the
Exchange Enterprise Server group has permissions that was mentioned in
various...Can I fix the exponent in scientific/engineering format?
This is sort of a continuation of my search to find a ppm number forma
Found someone who mentioned using engineering formats (kind of a
extension of scientific format). After a little tinkering, here's wha
I've found (using the values of 7E-3 and 7=-5 as examples):
format 7e-3 displayed 7e-5 displayed
.0E+0 .7E-2 .7E-4
0.0E+0 7.0E-3 7.0E-5 (REGULAR SCIENTIFIC NOTATION)
#0.0E+0 70.0E-4 70.0E-6 (EXPONENTS ARE MULTIPLES OF 2)
##0.0E+0 7.0E-3 70.0E-6 (EXPONENTS ARE...How can i asign MBF roles to user accounts?
Hello. I want to asign to user accounts the next roles:
- Order Management Customer
- Customer (Advanced role)
I was wondering how can I make this
Thanks for your help
Jose Ponce Aguilar
...Can i use Windows Search to find a number within Excel?
If i use Widnows search of the CONTENTS of files (not file names), i find in
Excel, that for cells that contain text, they can be found. But, it does
not appear to me that numbers can be found. Of course the number as Excel
stores it may differ from how it is displayed. But, does anybody know if
this is possible?
For instance, i have a cell with the number 3,709,227 in it, as it appears
in Excel (as formatted). I tried typing the number both with and without
the commas, into WIndows search, but Windows search still does not find the
Excel file that contains that number.
So, any kn...Paying a lot of money for a formal dress that you will only wear once can be frustrating. Used clothing stores can offer an extensive selection of formal wear at affordable prices that you or your d
Paying a lot of money for a formal dress that you will only wear once
can be frustrating. Used clothing stores can offer an extensive
selection of formal wear at affordable prices that you or your
daughter will love.
Used clothing stores are full of ite...Newbie q: Can't modify a database
I've been handed an access database in order to modify it (in the
programming sense), but when i open it it opens as an application,
without any apparent means of modifying the database structure. All it
will let me do is add or edit data.
Is there a secret trick to opening the database for modification, or
do I have to go to the owners of the database and have them save it in
a different way?
If you hold down the shift key while the database is opening it should
bypass any startup options code and take you straight to the database
If this doesn'...Can I have two Internet Mail Services in one Exchange 5.5 Organiza
My current environment consists of 6 mailbox servers and one server hosting
the internet mail service (Exchange 5.5 on Windows 2000). I need to use one
of the 6 mailbox servers for a product that will need to route outbound mail
to another server for other secure outbound services while the other 5
servers route to the current internet mail service. Is this possible? Can I
add a secondary internet mail service just for this one server? I am not able
to find any knowledge base articles for assistance.
Thanks in advance!
On Tue, 28 Jun 2005 15:36:10 -0700, "exadm"
&l...importing statements #2
I'm getting an error when trying to import my bank
statement. It reads "A transaction in the QIF file has a
date that could not be resolved and therefore was not
recorded into your Money file. Check your Regional
Settings in the Windows Control Panel to make sure they
match the date format of the QIF file, and then try
importing the file again." Please help! Thanks
...how can i graph with log-log scales? #2
I wish to graph pricing curves using a logarithmic x-axis. Is this possible
with Excel? If so, how do I do it?
> I wish to graph pricing curves using a logarithmic x-axis. Is this
> possible with Excel? If so, how do I do it? <
Use an XY (Scatter) chart type.
...How can i get more 3D shapes for Auto shapes in excel?
Please suggest how i can get more shapes (simple as well as 3D ) in Auto
Shapes of drawing toolbar in excel & word?
...sorting by date #2
I am having trouble sorting a table by date. When I choose to sort th
column by date - it sorts it alphabetically by date - i.e. with Augus
How can I have Excel sort chronologically, when the date include
month, day, yea
Message posted from http://www.ExcelForum.com
It sounds as if the dates are formatted as text. You can change this to an
Excel date value by inserting a helper column and using the following
formula (assuming your dates are in column A:
and copying down. Excel will then recognize the values as date values, not
text, and will sort chronol...Can we Take layaway payments from store #2
Hello, I have a customer that would like to make a payment on his layaway at
out other location. Can this be done? and how?
This is a multi-part message in MIME format.
Not without an add-on, which I've never seen to do this.
Check Point Software
=3D=3D=...Business Portal Install Error #2
I am installing BP 3 on a GP 9 server which is running Win2k3. SQL 2K is on
same server with an instance name (Not a Default server).
When I try to install BP I receive a error.
Declaring Type :
Target Site : LoadPackagerComponents
Error Summary : Failed Loading Packager Data Element (PD_GP_COMMON) for
Install Feature (BusinessPortal).
and it was hanged with the following message
Please wait while the setup wizard installs Microsoft Dynamics GP Business
Portal. This may take several minutes.
Status Loading data 1 of 21
T...How can I sort and maintain formatting?
I have a very large excel doc (well over 1,000 rows, by 30 somethin
columns) that require formatting (resizing the row height) each row b
hand. I have done all of that tideous work, but now I need to sort b
multiple columns, and when I do that, the formatting of the cells i
not maintained. (The size of the row stays, rather than moves with th
data) Please tell me there is a remedy and I haven't just wasted m
time formatting for nothing! Thanks for any and all advice
littlelostgrl's Profile: http:/...can't save files in subfolders using Word #2
I'm running Word on a Mac running OS X. When I go to save a file in
Word, it only gives me the option to save in the root files like
"Documents" or "Applications." How do I save the file into a
subfolder? On a PC, I would double click to open the folders until I
got to the folder I needed. That doesn't work here. Can someone help?
I'm sure this is something obvious I'm missing.
In article <firstname.lastname@example.org>,
> I'm sure this is something obvious I'...can i not allow duplicate values in the same column?
is there a way to set columns to not accept duplicate information?
Take a look at
In article <4765FB37-8F89-4220-A901-B289FDCDE23F@microsoft.com>,
excel newbie <excel email@example.com> wrote:
> is there a way to set columns to not accept duplicate information?
If the values are typed in you can use this:
"excel newbie" wrote:
> is there a way to set columns to not accept duplicate information?
...toolbar macros #2
I've gone through the routine to assign a macro to a toolbar button, even
down to getting the option to select the macro, but it isn't permanent. When
I click on the button afterwards,I get the same dialog to assign the macro.
However, I can permanently assign the same macro to a graphic in the sheet.
Second quandary - Can I assign that same macro to a cell which has only text?
...Conditional Formatting in Excel 2007 #2
I have been asked to prepare a spreadsheet that uses conditional
formatting on another cell. What it needs to do is that is a cell
contains a particular value i.e. between 2 and 6 the adjacent cell
will turn say blue, but the issue is that there is up to 6 different
rules that could be applied to that one cell. All of these rules then
need to work for the subsequent entries.
If anyone could help me with this issue I would be very grateful.
On Tue, 19 Oct 2010 03:10:07 -0700 (PDT), didi <firstname.lastname@example.org>
>I have been a...Excel 2002 error message #2
i am getting the following message in Excel 2002 "an
outgoing call cannot be made since the application is
dispatching an input-sychronous call". this appears when
copying some cells in the spreadsheet. Any ideas?
...Protecting hidden columns so they can't be unhidden ?
Is there a way to hide columns so that no one else can unhide them ? Need
to send a file with data in 2 hidden columns that I don't want to be
unhidden and I don't want to have to delete them.
Gary, easiest way is to hide the columns then protect the worksheet (Tools >
Protection > Protect Sheet). If there are cells that the recipients will use
for data entry, unlock them (Format > Cells > Protection > Locked) first.
You can also remove the row and column headers (Tools > Options > View > Row
& column headers) so it won't be immediate...How do I compare 2 worksheets, 1 old, 1 updated to find difference
I have 2 large worksheets of text information, the 2nd being an update of the
first, I need to identify/highlight the updated fields. Is there a way to do
There is a workbook compare add-in by Myrna Larsen and Bill Manville on Chip
Pearson's site you might try:
"alienstew" <email@example.com> wrote in message
|I have 2 large worksheets of text information, the 2nd being an update of
| first, I need to identify/highlig...Can't install Windows Updates on Vista
I'm running Windows Vista Home Premium with Service Pack 2.
I have 15 "Important" Windows Updates that won't install: 9 security updates, 3 windows updates for Vista, etc. One dates back to 12/8/09 and the most recent 4/13/10. They're starting to add up.
When I try to install them, some will fail due to a 8007371C error and the rest will say pending (until restart), but then after the restart they fail to install (but no error code).
I've tried installing them with UAC, anti-virus, and firewall off, but the result is the same.
When I try to install any of them ...2 Exchange Servers in the Same Domain
Microsoft Outlook SignatureHi,
Please help as I'm new to Exchange....
I have 2 Windows 2003 Servers both with Exchange 2003 installed in the same
domain, @ two different physical locations connected via a gateway to
If I have user on Server A, he can create a email in the gobal address list
and send it without error to a user on Server B but it never arrives @ the
server B's inbox?
Is there a way to track it?
You can enable message tracking...
CA...I can not delete a duplicate personal folders list
amazing that there isn't an easy fix for this. The instructions provided
simply don't work ( tools-email accounts-view change email accounts-deliver
to new account-finish-close outlook and reopen ), and none of the other
offered explanations have worked either. As this is such a common problem;
why hasn't microsoft provided a very EASY fix? I am more confused ( and
frightened ) and don't want to make the problem worse!