.CSV to .PRN
I am having trouble saving a .CSV file as a .PRN format - it is cutting the
information in the sheet off about 20 columns in - any suggestions? I am
doing the basic File - Save as.
Have you formatted the sheet with a fixed-width font so you can set the field
widths exactly? What is sum of field lengths? There used to be a limit of ~240
characters per line in PRN files.
On Mon, 18 Oct 2004 10:13:08 -0700, "Melissa"
>I am having trouble saving a .CSV file as a .PRN format - it is cutting the
>information i...Shared workbook-track changes off but file size still grows
I have a shared workbook with track changes off. I turned it off because I
have a macro to arrange the rows in a certain way which created a huge log.
The problem is that the file keeps growing. It starts out at 570k and by
noon, it is at 15 Mb.
To bring it back down, I have to take the book off shared, and put it back
on and it is back to normal.
Does anybody know the problem or know someone's website with experience in
...Does anyone have a format or template for a Education Cover Letter
Does anyone have a format or template for a Education Cover Letter?
To Whom It May Concern:
Enclosed please find an education.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"eb" <email@example.com> wrote in message
> Does anyone have a format or template for a Education Cover Letter?
"Suzanne S. Barnhill" <firstname.lastname@example.org> wrote in message
news:O3aNFsq2KHA.5212@TK2MSFTNGP04.phx.g...Creating a csv
I have a spreadsheet with a list of email addresses in the first column. I
want to create a CSV file. If I choose Save as---> csv and then open the csv
file in Notepad the list is saved as a list with carriage returns after each
email address and no commas. So how do i turn the list into a continuous list
with no breaks and a comma seperating each one? I'm using Excel 2007
Open the file in MSWord and do an edit|replace (or the MSWord 2007 equivalent)
to change the paragraph mark (under the More button and then under the Special
button) to a comma.
Tony Williams wrote:
...tsql to change oracle pswd
Is it possible to use tsql or sqlcmd to change an Oracle password?
Chuck (email@example.com) writes:
> Is it possible to use tsql or sqlcmd to change an Oracle password?
EXEC ('ORACLE CMD TO CHANGE PASSWORD') AT OracleSVR
Erland Sommarskog, SQL Server MVP, firstname.lastname@example.org
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
thanks, it seems so obvious now
...cell formatting zero padding on binary no's
I'm struggling through doing some binary math on excel. Ugh. You'd think
Excel is written by programmers, so they would see the value of having
some programmer-friendly bitwise math and binary, octal and hex formatting
stuff in there, if for no other reason than they could use it themselves.
Anyway, that's my rant, here's my question
I have some numbers in cells that I convert to binary
C5: 55 DEC2BIN(C5) gives me 1010101
I'd really like to display that as
.... ie with a leading zero and a space between the nibbles.
It appears that ce...Importing CSV files problem
I am currently working on a project that invloves
importing of CSV files to Excel. Double-clicking the CSV
file opens the file automatically in Excel. We have
enclosed our data in quotation marks (i.e. "SomeData") to
prevent errors arising from strings that have commas as
part of the data. This works fine for us.
However, The problem arises when we import data that look
like numbers written in scientific notation but are
actually some other data which should not be expressed in
scientific notation (example "1E306" is expressed
...changing item type
I have a lot of items added as sales inventory that should be services or
misc charge. Can I go into the back end and change this? How would this work
for items that have have or have had transactions associated with them?
Thank you for any assistance.
Well it works poorly. If you have quantities on hand, these need to be
adjusted out first.
The best option is to create new items with the proper settings and change
the others to discontinued.
Richard L. Whaley
Author / Consultant / MVP
Documentation for Software Users
Get our Free Tips and Tricks Newsletter and check out our book...number keep being formatted as date
I'm a newbie so forgive me if this question has been answered. I
couldn't find much with the search option.
Okay here's the problem.:confused: :eek:
I want to enter this: 1-2 into a cell but Excel keep turning it into
2-Jan. How do I turn this off?
the 1-2 is just a designation of point 1 to point 2.
Thank you for helping.
baxu's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27861
View this thread: http://www.excelforum.com/showthread.php?threadid=4736...Custom Date Format #2
When working with data from a spreadsheet which originated from a much
earlier version of Excel (Excel95, I believe), which I'm now trying to use
with Excel 2003. I'm having trouble with the formatting of the date being
interpreted as a formula and forcing an equals sign "=" to appear next to the
When the file is first opened, the original data appears correctly.
However, after editing the data in the field and pressing the 'enter' key,
the date displayed on the sheet shows "00-Jan-00". When I use the arrow keys
to go back up to that parti...CSV elements don't get split up in cells
I recently installed a German version of excel and now when I open m
CSV files they don't get seperated anymore by the commas. The whol
line is just written in one cell.
When I had the US version installed the data was split up after eac
comma and distributed into the corresponding cell.
How can I achieve the same thing in the German version
Message posted from http://www.ExcelForum.com
You could try renaming the file to .txt rather than .csv When you try to
open this in Excel it will start the Text Import Wizard which will give you
much more control over the import of th...formatting cells #3
Question: Recently, when attempting to format cells, whether it's for
color fill or lines, boldface for type,and a variety of other cell
formats--I now get a warning box which says 'too many different cell
formats' even when I work with a duplicate of the spread sheet from
which I have cleared all formats.
Is there some way to correct this malfunction. I have worked for over
ten years with excel and have not had this problem. It appeared on my
G4 and now has carried over to my G5.
I'm running Excel 2004 11.3
Excel has a limit for the number of different formats it can...Change Outlook 2002 from Internet mode to corporate mode
Currently, I have installed Outlook 2002 in Internet Only
How do I change to Corporate or workgroup mode?
On Thu, 6 Nov 2003 15:44:50 -0800, "wayne"
>Currently, I have installed Outlook 2002 in Internet Only
>How do I change to Corporate or workgroup mode?
Outlook 2002 does not use 'modes'.
Chicago, Illinois, USA
Email Client: Microsoft Outlook 2002/2003
News Client (Text): Fort� Agent 1.93 www.forteinc.com
News Client (Binaries): News Rover 9.0 www.newsrov...Saving As .CSV
Hello, here's the situation: I downloaded an .xls file from my broker and
opened it in Excel. The original file was delimited by commas and I had to
choose comma delimited in order for Excel to display it in columns/rows
correctly. I made some changes to the file, then saved it with a new name.
The problem is, I can find no way to save it as a comma delimited file
again. Saving it as a Workbook places quotes around the commas and creates
spacing between text (when I view it in Wordpad), and saving it as a Text
File (Tab delimited) does just that--makes it TAB delimited, not comma...Changing Costs in Detailed Sales Report
I just opened a new location and I have specified my costs in HQ Mgr under
Supplier Tab in Item properties. And I also checked the Supplier tab in Item
properties in the Store Ops Mgr, my cost is there.
But when I ran a Detailed Sales report for yesterday, some of my items'
costs are missing and listed as $0.00. So I open HQ Mgr and issued Worksheet
302 for the new location. I did a couple of test transactions today and ran a
Detailed Sales report for today, and it shows the costs of the the test
But detailed sales report for yesterday still shows $0.00 costs. How do...Block HTML Formatting?
I have a web-based app that accepts emails sent to it by Exchange
users. I'd like to have Exchange format those emails so that if my
users send mail with HTML formatting in the email the emails will be
converted to plain text before being forwarded to my app server. Is
that possible in Exchange?
rickKasten@gmail.com (DrStrangepork) wrote in
> I have a web-based app that accepts emails sent to it by Exchange
> users. I'd like to have Exchange format those emails so that if my
> users send mail with HTML formatting in t...change user's properties
This "problem" seems tricky to me and I'm not sure if it is related exactly
to the Exchange or the AD:
When I start typing the name of a user in the To: field of a new message in
Outlook, I get the suggestion of the name of the user. This suggestion is the
name of the user followed by SOMETHING in "<" and ">". The problem is that
the SOMETHING is wrong! I can see the same value in the user's properties in
Outlook, in the last tab (E-mail addresses), in a line starting with X400 and
then a property starting with "s="
im using A file with records in my mfc application, i need to read*/write
records to the file anybody ahs a clue where should i start?
Take a look at CStdiofile and CString::Format() (for output) and
CString::Tokenize() (for parsing input). You can use ReadString() and
WriteString() to access the file line by line.
"fima" <email@example.com> wrote in message
> im using A file with records in my mfc application, i need to read*/write
> records to the file anybody ahs a clue where should i start?
I have a line chart which is pulling data from a different
sheet in my workbook.
The X axis is the date, formatted: Jan-XX, Feb-XX, etc.
The Y axis is dollar amounts formatted as 200000, 400000,
etc. - increasing by 200K at each interval. - this is
The X axis is defaulting to date the same date all the way
across, "Jan-00, Jan-00, Jan-00". So, I'm seeing Jan-00
12 times, where I would like to see each month of the year.
When I change the X axis to so that it reads each month,
as I'd like...
The scale on my Y axis changes to:
min = 0 (this is correct)
ma...Is it possible to change the default number format in Excel?
Is it possible to change the default number format in Excel?
You can change it, but I bet you won't want to.
You can change the normal style of a workbook by:
format|style|choose normal from the dropdown
click on the modify button and change the format to what you want.
First bad thing:
Styles are kept with workbooks. So you'll have to do this to any new or
Partial good thing:
You can create a workbook template named book.xlt and store it in your XLStart
folder. If you change the normal style for this template file, then any new
workbook that you start by...Format date to UPPERCASE
Excel 97: Is there a way to format the date, currently set to "dddd, mmmm d,
yyyy", in uppercase letters?
If by "Date" you're referring to the current date, this formula should
accomplish what you're looking for:
=UPPER(TEXT(NOW(),"dddd, mmmm d,yyyy"))
I hope this helps.
"Bruce LeBlanc" <firstname.lastname@example.org> wrote in message news:<OVHfBuYUDHA.964@TK2MSFTNGP09.phx.gbl>...
> Excel 97: Is there a way to format the date, currently set to "dddd, mmmm d,
> yyyy", in uppercase letters?
Niek and Paul,
Th...Date format problems
I have a column that consist of a date/start time stamp (as shown
above). I have changed the format of the column using custom that
follows this format, however when I try to scatter chart this, I get at
1900-01-00, 1900-01-10 etc. for one of the axis. Any idea how to keep
the original contents and why is it going to a 1900 year? Thanks in
Monty's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33605
View this thread: http://www.excelforum.com/s...Contract lines - number of items
Just started with MS CRM 3.0.
I have set up contracts and contract lines, based on a Time template,
for my clients. Normally their contract duration is a year with monthly
billing intervals, so my question is do I:
- Enter the full year's minutes in the time allotment
or can I (preferred):
- Enter only a months minutes in the time allotment, but put Quantity
at 12. My intention here is to reset the months minutes each month.
I was just wondering if you had found out the procedure, i am in the same boat!
> Just star...Conditional Formatting
Is there a way that when you insert rows, the conditional formatting on the
adjacent rows does not copy into the inserted/new row?
Here are tow ways of inserting a row when the text changes in Column A (I
don't know why you are inserting rows).
Dim LastRow As Long
Dim x As Long
LastRow = Cells(Rows.Count, 1).End(xlUp).Row
Application.ScreenUpdating = False
For x = LastRow To 3 Step -1
If Cells(x, 1).Value <> Cells(x - 1, 1).Value Then
If Cells(x, 1).Value <> "" Then
If Cells(x - 1, 1).Value <> "...legacyExchangeDN
I have a Exchange2K3 server on a Windows2K3. It is an upgrade of Exchange5.5
The lay out was a bit different, and some mailboxes have inherited
"unwanted" values in that "legacyExchangeDN" property: recipient containers
which no longer exist, mailbox (hidden) names from a different naming
May I change at will that property for several users? ... without having to
reinstall my whole server, of course ;-)
Why? Is it broken?
It *could* be changed, although I advise you be careful changing that. Test
the heck out of it in your en...