On 24/05/2008 00:12, Tyson Fearrington wrote:
Would someone please assist me with transferring a microsoft excel spreadsheet which will only
allow me to save it to "all files" or microsoft excel, and I want to convert it it to
"tab delimited". How do I get it open office, and then what will I need to do to convert
it to tab delimited? Thanks!
Tyson
[EMAIL PROTECTED]
OpenOffice's Calc will open an Excel spreadsheet unless it was created
in what Microsoft refers to as "Office 2007" format. So, open it with
OpenOffice (on Windows, right click on the document and choose "Open
with..."; then browse to soffice.exe or scalc.exe in the folder where
you installed OpenOffice). Once the file is open in Calc do File>Save
as, choose "Text (csv)" as the type of file and, when offered the
choice, choose Tab as the field delimiter.
If the document is in Office 2007 format, install the free viewer at
http://office.microsoft.com/en-us/downloads/CD102258581033.aspx, open
the spreadsheet with it and cut/paste the data into Calc. Then save the
data as above in Text(csv) format.
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
