Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
Need Help With EXCEL Save As CSV
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  3 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
stepheneng  
View profile  
 More options Dec 15 2006, 6:09 pm
Newsgroups: microsoft.public.mac.office.excel
From: "stepheneng" <stephen...@aol.com>
Date: 15 Dec 2006 15:09:54 -0800
Local: Fri, Dec 15 2006 6:09 pm
Subject: Need Help With EXCEL Save As CSV
I am probably doing something stupid, but, when I try to save a
Worksheet to CSV, I get messages saying that i can only save one page,
then one which says some features won't be saved... I go through those,
and a new Worksheet icon appears on the desktop with the .csv suffix.

BUT, when I re-open the Worksheet, the Worksheet does NOT appear in CSV
format:  it reverts to the columns and rows format like a regular
worksheet.

Oddly enough, when I look at it through the View menu on MacLink, there
is appears in comma-separated format.

Can anybody tell me what I am doing wrong in saving?????


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
CyberTaz  
View profile  
 More options Dec 15 2006, 10:13 pm
Newsgroups: microsoft.public.mac.office.excel
From: CyberTaz <onlygeneralt...@com.cast.net>
Date: Fri, 15 Dec 2006 22:13:36 -0500
Local: Fri, Dec 15 2006 10:13 pm
Subject: Re: Need Help With EXCEL Save As CSV
It sounds like you're doing nothing wrong - nor is the software. One of the
aspects of a CSV is that Excel can reopen the file as though it were a
standard .xls so you can edit & save changes to it using Excel. If you open
the file in a text editor it will open in the comma-delimited appearance.

Regards |:>)
Bob Jones
[MVP] Office:Mac


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Paul Berkowitz  
View profile  
 More options Dec 16 2006, 12:34 pm
Newsgroups: microsoft.public.mac.office.excel
From: Paul Berkowitz <berkowit@spoof_silcom.com>
Date: Sat, 16 Dec 2006 09:34:53 -0800
Local: Sat, Dec 16 2006 12:34 pm
Subject: Re: Need Help With EXCEL Save As CSV
On 12/15/06 3:09 PM, in article
1166224194.021881.48...@f1g2000cwa.googlegroups.com, "stepheneng"

<stephen...@aol.com> wrote:
> I am probably doing something stupid, but, when I try to save a
> Worksheet to CSV, I get messages saying that i can only save one page,
> then one which says some features won't be saved... I go through those,
> and a new Worksheet icon appears on the desktop with the .csv suffix.

> BUT, when I re-open the Worksheet, the Worksheet does NOT appear in CSV
> format:  it reverts to the columns and rows format like a regular
> worksheet.

> Oddly enough, when I look at it through the View menu on MacLink, there
> is appears in comma-separated format.

> Can anybody tell me what I am doing wrong in saving?????

You're not doing anything wrong. That's how Excel displays CSV files - which
are actually text files. If you want them displayed as text, with commas,
open them in a text editor.

Drag the .csv file onto TextEdit and you'll see it displayed how you wish.

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X  or 2001. It's often impossible to answer your questions
otherwise.


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »